Import FoxPro Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can a FoxPro Table be imported into Access 2000? Setting up as a Visual
FoxPro Database through ODBC doesn't work.
 
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.
 
Back
Top