i have mistakenly made some changes in .dbf file (opening through MS Excel 2007). After saving its structure changed and it is no more useful. File is used as a database for Fact Software. S/w is not able to open the file and has stopped working. how can i retrieve the original dBase file. (file was created using visual foxpro)
No.6, 4th Block, Treasury Layout, Bogadi II Stage (South) Mysore 570 026 SOUTH INDIA
There are two choices to solve this problem.
1. If there is a back up file with, normally, .bak extension it can be copied to
to a .dbf of the original name and used.
2. A delimited text file can be created from the Excel in which it was opened
and saved and then a new .dbf file with the the exact file name and field
names and types be created in VFP and that file populated with the data
from the delimited file with the "append from ....... delimited" command
from the DOT prompt of VFP. The field name and type should be exactly
the same as that of the origianl .dbf file.