Importing a DBF file

I am trying to import a dbf file created using visual fox pro and it says
'External table is not in the expected format' What might be the reason for
not able to import. Is it something to do with field size or name.

What is the best way to get these .dbf file to import into my access
database.

thanks.

re: Importing a DBF file

The import feature for dbf files in Access is for old FoxPro 2.6 and
below tables. There is an ODBC driver for Visual FoxPro 6.0 and older.
The newer version of Visual FoxPro 7.0, 8.0 & 9.0 have an OLE driver.

Easiest way to get the data into Access is while in Visual FoxPro at
the command window issue the following commands...

"use <<dbf file name>>"
"copy to <<new file name>> fox2x"

Example:
use 10875
copy to new10875 fox2x

This will convert the Visual FoxPro table to an older version FoxPro
2.6 dbf. Then you can import the older version into Access.