recognizing FoxPro9 DBF files

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

Guest

Hi All,

Excel 2003 generally recognizes DBF files, except those created with
FoxPro9. Can I do anything either in Foxpro or in Excel to have Excel
recognize these DBF files?

Thanks,
Stefi
 
Hi Stefi,

Excel natively recognizes FoxPro 2.x format files (the old Dbase IV format).
Over time new data features have been added and Fox DBFs with data features
added through VFP6 are accessible via ODBC. Data features that have been
added through VFP9 aren't compatible with ODBC and they can only be accessed
using OLE DB and ADO. However, VFP7-9 files that don't have any of the new
data features will still be accessible via ODBC.

Links for the ODBC driver and OLE DB data provider are below my signature.

--
Cindy Winegarden
(e-mail address removed)


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
 
Back
Top