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

This is the type of question that Google is good for. There are a lot of
links he
http://www.google.com/search?hl=en&s...xpro+9&spell=1

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Stefi" wrote:

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



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




"Stefi" wrote in message
...
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