Linking to .dbf's using MS Access

[coned]

I've historically linked to my Foxpro 3.0 .dbf files using MS Access 97 but now would like to use Access 2000. It doesn't appear to support these Foxpro .dbf files - how do you get around that?

 

[rgbean]

Use the current VFP ODBC driver available at

http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx.

Or, now that it's available (See Craig's announcement message earlier today) you can use the publicly available VFP OLE DB Provider if you are more comfortable with ADO. It's available at

http://microsoft.com/downloads/deta...58-7A94-4AE1-A59E-965869CB3BC9&displaylang=en

.

Rick

 

[craigber]

Actually, the OLE DB Provider would be a better choice as OLE DB is a better technology than ODBC.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"