FoxPro ODBC

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

Guest

How do I import or link to DBF files using the FoxPro ODBC instead of the jet
data engine?
 
Hi Booner,

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

In Access, File > Get External Data > Import/Link > Files of Type > ODBC
Databases () > Machine Data Source...

You'll need to decide whether to use the DBC option or the Free Table
option. Basically, if there is a DBC file in the directory where the DBFs
are then point to it, otherwise use the free table option and just point to
the directory.
 
Thanks Cindy,

Worked like a charm.

Cindy Winegarden said:
Hi Booner,

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

In Access, File > Get External Data > Import/Link > Files of Type > ODBC
Databases () > Machine Data Source...

You'll need to decide whether to use the DBC option or the Free Table
option. Basically, if there is a DBC file in the directory where the DBFs
are then point to it, otherwise use the free table option and just point to
the directory.
Click to expand...
 

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

Similar Threads

Importing FoxPro 2.6 DBF Into Access 2007 1
Import ODBC Database using VBA 1
Linking Foxpro 8
ODBC Driver Error Message encountered 1
Problem Linking Foxpro 9 .DBC in Access 2003 7
ODBC and DBF File in MS Access 8
Error Linking to VFP Tables 3
TransferDatabase of FoxPro file produces error (Access XP) 6

Back
Top