By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,570 Members | 999 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,570 IT Pros & Developers. It's quick & easy.

Importing a DBF file

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.