recognizing FoxPro9 DBF files

[Stefi]

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

 

[Dave F]

This is the type of question that Google is good for. There are a lot of
links here:
http://www.google.com/search?hl=en&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=excel+foxpro+9&spell=1

Dave

 

[Cindy Winegarden]

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