Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Anybody can repair this dbf file for me?

Status
Not open for further replies.
You might try This is not a personal recommenmdation, as I have never used them, but I know they have been around for a long time, and they advertise the service you are looking for.

Here's another possibility: At a quick glance, I couldn't see any mention of DBF repair, but I have their bookmark in my "DBF Repair Tools" folder, so they might be worth following up.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads
 
I ran the store.dbf through a tool I have and it comes up with some stuff.

Are there character fields in a non-english form?

Do these columns mean anything to you?

SHO_R_K
SHO_R_C
TAR
SHO_T
TAR_T

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.
 
I have spent a few minutes analysing the content of your dbf using a hex editor.

I can tell you there is some readable data in there, no header so the structure is not easily determined.

The records seem to be 219 bytes in length, but there seem to be places where other information has overwritten
the content and perhaps 'shifted' records back and/or forth.

If you have a back-up of the table, even empty, which has the structure there is a chance I could recover some
of the data, probably not all though.

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.
 
Mike Lewis

The DBF repair tool is there
Screenshot_-_2_2_2021_5_22_46_AM_q8q5wj.png




If you want to get the best response to a question, please check out FAQ184-2483 first.
 
I have tried the unregistered version of that Mike, but it has no success with this file.

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.
 
GriffMG
I have tried as well, the table seems too damaged for that tool.



If you want to get the best response to a question, please check out FAQ184-2483 first.
 
I agree Mike. U/S with a capital F

B-(

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.
 
This table isn't a table. There are some megabytes from harddisk added into dbf file as recovery.
File stared with startheader of dbf but only 12 bytes than is some part of records
There is an header of dbf in this file.
version DBF dBASE Level 5
fields 20
length of record 219 bytes
original records 10063
but than records are not contignous
I have self hard created table without of index with 50 records to testing here are 2 starting records

SHO_R_K SHO_R_KC ..... COD_M ........... COD_TA COD_TAFZ MQDAR
10463 10463 39 550 565 1.00
10482 10482 39 12 12 700.00
fields ar persian ??
after 52 record is bad offset than after 92 record second bad offset

with some information perhaps is possible to hardcreating this file without some records this with bad offsets

Best regards

 
 https://files.engineering.com/getfile.aspx?folder=91035c94-7998-4a2d-af2a-2f76d20b8351&file=output.dbf
Hi,

There are quite a few repair tools around - some of them even free. Just google "repair dbf".

hth

MarK
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top