FoxPro ODBC

G

Guest

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

Cindy Winegarden

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.
 
G

Guest

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
TransferDatabase of FoxPro file produces error (Access XP) 6
Error Linking to VFP Tables 3

Top