Link to home
Start Free TrialLog in
Avatar of newexhsh
newexhsh

asked on

convert foxpro .DBF to access .mdb

hello
Are there any software can convert foxpro .DBF to access .mdb?
Or is it foxpro built in has this function or Access built in has this function?
thx everyone to reply
Avatar of CarlWarner
CarlWarner
Flag of United States of America image

You should be able to link to a FoxPro table (.dbf) from MS Access to import the data into Access via a FoxPro ODBC driver that is freely available from MS.

Visual FoxPro ODBC Driver
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx
Avatar of Cyril Joudieh
in Access
open a new database
go to tables
right click on empty space
click on Import for follow instructions
In most newer installations of Access, the Import feature for FoxPro tables will be dimmed out and unusable.  This is exactly why I mentioned that you would need to download the FoxPro ODBC driver that I posted above.

The reason it might be dimmed is that the ODBC driver is no longer included in the later MDAC driver packages from MS.  So, the ODBC driver needed may have to be downloaded and installed separately, if you haven't already done that.

ACC2000: No Option to Import, Link, or Export to the FoxPro File Type
http://support.microsoft.com/default.aspx?scid=kb;en-us;225861
Avatar of newexhsh
newexhsh

ASKER

hello...
i dont know why i still cannot open the foxpro table in access even i follow your instruction. It said "the fomat not support" or something like that.
Please post exactly what the error message says.
I am not using eng windows, so just translate it to english.
The error message" External data is not an expected format"
just like that
thx
The error number is "3274"
thx
ASKER CERTIFIED SOLUTION
Avatar of CarlWarner
CarlWarner
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial