Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't open Excel Files [email protected] Excel Discussion (Misc queries) 3 September 13th 06 01:14 PM
Files open only when excel already open [email protected] Excel Discussion (Misc queries) 3 May 25th 06 03:11 PM
I cant open files unless I open the Excel program first ElaineAng Excel Discussion (Misc queries) 3 February 16th 06 02:54 PM
CANNOT OPEN EXCEL FILES HR Excel Discussion (Misc queries) 1 November 17th 05 02:21 PM
Can not open excel files without open application Taarfa Excel Discussion (Misc queries) 3 July 9th 05 11:56 PM


All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"