Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012

    Unanswered: Help with dBase IV

    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)

  2. #2
    Join Date
    Sep 2009
    Provided Answers: 1
    Save the excell version as a csv or tab delimited copy. Then restore a backup of the dbf and use either foxpro or dbaseIV to zap the backup and load the csv file. You may also need a way to re-create the indexes.

  3. #3
    Join Date
    Nov 2002
    Provided Answers: 1
    What has already been suggested is a good approach.

    But another somewhat 'kludgy' approach would be to use Excel 2000/2003

    Using your Excel 2007, open the file that you saved.
    Then do a SaveAs into Excel 2000/2003 format.
    Open the file with Excel 2000/2003.
    Highlight only those Rows & Columns which have data in them. (No extra blank columns nor extra blank rows)
    Then do a SaveAs into the DBF4 format.

    NOTE columns which have numeric values or numeric appearing values (Zipcodes, Phone Numbers, etc) will be saved as Numeric DBF Field values unless you take extra steps to prevent it.

    Basically you should NEVER make changes to a DBF file with another application like Excel. While it can be used to VIEW data, it is much too easy to corrupt the DBF file unless you REALLY know how to prevent it.

    Good Luck

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts