FoxPro to Access2000 Conversion troubles

[Mike Utley]

I need to convert several tables from FoxPro 3 to
Access2000. I'm using the ODBC method, but when I try to
do the ODBC import, I get an error indicating that
the "decimal precision is too small". Anyone seen this
before, and what can I do about it?

I have a feeling it has to do with the FoxPro ODBC driver,
but I can't find any updates to fix the thing.

Suggestions? Thanks in advance!!

Mike

 

[Albert D. Kallal]

It is possible you are trying to import some number data into a access field
that is only a double precision?

If you are using a append query..then likely you need to import those
amounts into a currency field...and not a number field.

It is not clear if you are using a make table query...or a append query.

(can you view the linked data?)

If that does not work, then I would even consider importing to a text
field..and then converting that to a currency field.