Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 How I view the contents of a damaged dbf file ?

Author  Topic 

artuaslella
Starting Member

1 Post

Posted - 2014-10-04 : 10:30:44

I want to view the contents of a dbf file but one column appears with
"strange characters". It seems to be locked or encoded or encrypted. I
can see the other columns with no problem. The problem exists only in
one column. Is it possible to "unlock or decode or..." and view the
contents of that column?
For viewing the contents of the dbf file, I use the programs:
- DBF Viewer 2000 v1.35
- DBF Viewer Pro

ralfeger
Starting Member

3 Posts

Posted - 2014-10-04 : 16:34:12
Hi.I'm not completely certain but I think you have a dbase file that is corrupted. I believe that if it was encrypted, you wouldn't be able to read any of the fields. But you can try view file with help DBF Viewer Tool. http://www.dbf.viewertool.com/
- Advanced file analysis engine allowing users to view FoxPro files that were seriously damaged in all sorts of data corruption incidents
- An integrated database browser that assists users who don’t know how to view corrupted dbf file data
- Recovery of the database structure, data and associated MEMO field files
- Possibility to manually specify the format of the output DBF file
- Detailed database recovery log.
Read more information here:
http://www.filerepairforum.com/forum/databases/databases-aa/dbase-iv-clipper-foxpro/257-%E2%80%8Bi-want-to-view-the-contents-of-a-dbf-file[url][/url]
Go to Top of Page

Lincolnburrows
Yak Posting Veteran

52 Posts

Posted - 2014-10-15 : 03:13:23
If you are unable to read the file which in .dbf format then open it in excel and save it as .csv file and read the file.
Go to Top of Page
   

- Advertisement -