Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Why can't Excel open VFP dbfs?
- Thread starter bkamajian
- Start date
FoxPro now used a modified DBF format. You can save and use your DBF as "TYPE FOX2" or you can copy it to a "TYPE DIF" which Excel can read.
There are a myriad of other related solutions, but those should answer your question.
Brian
There are a myriad of other related solutions, but those should answer your question.
Brian
To expand on Brian's explanation, VFP tables have a header structure that is different than the "old" .DBFs, which makes them appear to non-VFP aware applications as invalid.
Excel can open these files if you've created a VFP ODBC DSN for it, and then choose that as the Import File source.
Rick
Excel can open these files if you've created a VFP ODBC DSN for it, and then choose that as the Import File source.
Rick
- Status
