Results 1 to 5 of 5
  1. #1
    Join Date
    May 2012
    Posts
    2

    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
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    Wrong forum. This forum is for IBM corporation DB2 product family.

  3. #3
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    As has been mentioned, this part of the forum is for DB2. There is a part of the forum called Other with some dbase iv topics.

    However - with your request, you would need to restore from a valid backup to get back the original data.

  4. #4
    Join Date
    Jun 2007
    Location
    No.6, 4th Block, Treasury Layout, Bogadi II Stage (South) Mysore 570 026 SOUTH INDIA
    Posts
    5
    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.


    G.BADARIVISHAL
    gbadarivishal@yahoo.co.in
    22-05-2012

  5. #5
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    I believe it was the attempt to use it in Excel that caused the damage. . . Possibly i misunderstood.

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
  •