Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't open Excel Files | Excel Discussion (Misc queries) | |||
Files open only when excel already open | Excel Discussion (Misc queries) | |||
I cant open files unless I open the Excel program first | Excel Discussion (Misc queries) | |||
CANNOT OPEN EXCEL FILES | Excel Discussion (Misc queries) | |||
Can not open excel files without open application | Excel Discussion (Misc queries) |