Using excel to open dbf files

R

robot

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

Cindy Winegarden

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot open dbf file created in Visual Foxpro 7 or 9 in EXCEL 2010 0
cannot link Foxpro file as table, access2000 3
Can an access form write to a dbf file? 9
recognizing FoxPro9 DBF files 2
When will save as "DBF" be a reality from Excel 2007 ? 1
HOW DO I CONVERT EXCEL FILE TO DBF FORMAT IN OFFICE 2007 ? 1
how to convert excell file into dbf for foxpro 2
Query a dbf file 9

Top