May 15, 2015 at 11:57 am
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?
May 16, 2015 at 3:58 pm
Quick thought, try import the data rather than opening the file with "file open"
😎
May 19, 2015 at 3:20 pm
And at last, below the guide how to recover .dbf file, see steps...
1.Open the dBase command line from the Windows Start menu.
2.Log into the local dBase software with your username and password.
3.Click on the dBase command line section of the window that is open.
4.Type "dbf /recover yourDbaseFile.dbf" into the command line, where "yourDbaseFile.dbf" is the name of the dBase file whose tables are corrupted.
Press "Enter." dBase takes some time (ranging from a few minutes to a few hours, depending on the size of the database) to analyze and repair the file and its contents. You are alerted when this process is finished.
Another methods contains referred link and might be effective in case manual ways can’t help, look below…
http://www.filerepairforum.com/forum/databases/databases-aa/dbase-iv-clipper-foxpro/1564-how-to-recover-dbf-file - a lot of different opinions and solutions connected with databases
http://www.dbf.openfiletool.com/[/url] DBF Open File Tool - paid software, but it has very high percent of success restoration .dbf files and free demo version
August 1, 2017 at 1:54 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply