Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert dbf table to Access
Message
From
21/10/2008 18:45:07
 
 
To
07/10/2008 14:09:05
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01353365
Message ID:
01356169
Views:
27
>>Anyone know how to convert a dbf table to MS Access? This table has memo fields that need converting also.
>
>I do this monthly in Access 2007. I open MS Access and start a new blank database and then I click on External Data, ODBC Database, Import Source data into a new table in the current database, machine data source, Visual Foxpro Database, in the configure connection window I choose free table directory and click on the browse button to select the directory with the tables, (you can pick a database if you choose visual foxpro databases (.dbc) but I don't do it that way because I just want the tables), and then click on OK. It brings in all of my VFP tables including memo fields.

Tracy -
Have you tried this with autoinc, logical, and date fields? I can get it to work with 1 table in the dbc but not another.
Thanks
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform