Error while importing FoxPro table into Access 2003

[wesj]

I need to import some data from a FoxPro datatabase into Access 2003,
but after it starts importing I get the following error & the import
cancels:

"ODBC--call failed
[Microsoft][ODBC Visual FoxPro Driver]Error: Column 7 ( abs_x )(#0)"

This happened when importing one particular table. When I tried
importing them all at once, I received so many errors I lost count of
them & forgot what most of them said, many were similar to this
one(such as: "Error Column ' ' (#0)").


I believe I have the latest FoxPro drivers( 6.01.8629.01 ), downloaded
from:
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx

The same errors were also received while importing into Access 2007
instead of 2003.


Can anyone tell me what's the problem is & how can I get past it?

Thanks!

 

[Cindy Winegarden]

Hi Wes,

Do you have any idea what the data actually looks like? Would you be able to
send me one small table that gives the error messages you are talking about?
Zip up and send me the DBF, and FPT, CDX, DBC, DCT, and DCX if present, and
I'll take a look.