ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Using excel to open dbf files (https://www.excelbanter.com/new-users-excel/144520-using-excel-open-dbf-files.html)

robot

Using excel to open dbf files
 
Hello,

I use Excel XP and Windows XP.
I can open a dbase dbf directly in Excel, but not foxpro dbfs.

How can I open foxpro dbfs in Excel? Suggestions are most welcome!



Cindy Winegarden

Using excel to open dbf files
 
Hi !

Over time, new data features have been added to FoxPro DBFs. DBFs that are
in the old Fox2x or dBASE format can be opened natively by Excel. Visual
FoxPro DBFs created with VFP6 and below (and also Fox2x tables) can be
opened via ODBC. If there is a DBC file present, point your ODBC connection
to it, otherwise use the "free" table option. DBFs having new data features
added in VFP7 and above can only be accessed in code using OLE DB and ADO.
DBFs created with VFP7 and above that don't have any of the new data
features are still ODBC compatible.

--
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




"robot" wrote in message
...
Hello,

I use Excel XP and Windows XP.
I can open a dbase dbf directly in Excel, but not foxpro dbfs.

How can I open foxpro dbfs in Excel? Suggestions are most welcome!






All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com