Cannot open dbf file created in Visual Foxpro 7 or 9 in EXCEL 2010

R

radovidsudar

New Member
Before upgrading to EXCEL 2010, I am able to open dbf files created in Visual Foxpro 7 or 9 in Excel 2003.


I am not sure why after installing EXCEL 2010 I am no longer able to open the file.


I get the error message when I tried opening the dbf file in Excel 2010 "the file you are trying to open is in a different format than specified by the file extension"


I have tried opening the dbf file via the File Open method but it still cannot work.


If I copy the file to a lower dbf format (type fox2x) then I am able to open the file in Excel 2010


Does Excel 2010 support dbf files created by Visual Foxpro 7 or 9?
 
RHD: Visual FoxPro is an abomination from a long time ago ;-)

You probably need to go ask this at a Microsoft related forum....
 
Perform these actions to resolve this issue

You need to create an environment under which the table is NOT validated when it is opened. This can be achieved by the command -SET TABLEVALIDATE TO 0. Now you can easily open your tables.

These are some “Prevention Steps” to prevent your data from corruption:

Try to put a code in your program that automatically creates a duplicate copy of your tables (columns & rows), index files and databases.
Set-up a back-up routine.
Inform the user to properly shutdown the computer and regularly perform back-up.
Use UPS for power back-up


If you can't resolve the issue, then foxpro database is seriously damaged and you may apply http://www.dbf.openfiletool.com/ DBF Open File Tool
 
You must log in or register to reply here.
Back
Top