Import FoxPro Table

G

Guest

Can a FoxPro Table be imported into Access 2000? Setting up as a Visual
FoxPro Database through ODBC doesn't work.
 
C

Cindy Winegarden

Hi Chris,

Hi haven't really described what "doesn't work" means for you.

First, be sure you have the latest FoxPro and Visual FoxPro ODBC driver,
downloadable from msdn.microsoft.com/vfoxpro/downloads/updates/odbc .

Over the years (since VFP7), new data features have been added to Visual
FoxPro tables, and these new features are not compatible with ODBC. They
are, however, compatible with the FoxPro and Visual FoxPro OLE DB data
provider, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates.
Tables created with VFP7 and later that do not have any of the new data
features will still be compatible with ODBC. Knowing whether your tables
have any of the new data features or not will be important for you.

You will need to determine whether your DBFs are part of a "Database
Container" or not. If a DBC file is present with the DBFs then you will need
to link to the DBC file; otherwise link to the directory where the DBFs are.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top