Linking to Visual Fox Pro

G

Guest

Hi. I am using Access 2002. Is there any way to link to a DBF file
generated in Vixual Fox Pro?

Thanks,
Mike.
 
M

[MVP] S.Clark

Choose File / Get External Data / Link from the main menu. Change the Type
combo box to *.dbf.
 
C

Cindy Winegarden

Hi Mike,

You'll need to use ODBC for reliability but you'll need to find out a little
more about your data. If you've got "free" tables then set up your ODBC data
source to the directory where they are. If your tables belong to a "Database
Container" - a DBC file will be present, usually in the same directory as
the data - then link your ODBC data source to the DBC file.

Over the years, new features have been added to Fox data tables. The ODBC
driver is only compatible with features used in VFP6 and under, although
tables created with VFP7, 8, or 9 that don't use any of the new features
will still be compatible with ODBC.

Otherwise you'll need to use OLE DB.

Be sure to use the latest driver - it's downloadable from
http://msdn.microsoft.com/vfoxpro/downloads/updates and it's version
6.01.8629.01.
 

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

Can't use ODBC-link from Access 2007 to Visual Fox pro (.dbf) 2
Loading a Fox Pro *.dbf 7
converting visual fox pro 1
Reading Fox Pro Files 5
Import or Linking a Table 2
Visual Fox Pro export to Excel 1
ODBC drivers for Visual Fox Pro 4
visual fox X excel 1

Top