tags:

views:

1605

answers:

3

I have been given a set of COBOL DAT, IDX and KEY files and I need to read the data in them and export it into Access, XLS, CSV, etc. I do not know the version, vendor of the COBOL code as I only have the windows executable that created the files.

I have tried Easysoft and Parkway ODBC drivers but I have not been successful in reading the data from the files.

I do not have access to the source code as the company that was distributing this product shut down.

+2  A: 

A few possibilities.

1/ See if you can find the names of the people that worked for the company. They may be helpful.

2/ Open the DAT file in a text editor. The data may be decodable from that. If the basic format can be discerned, quick'n'dirty code can be written to extract it.

3/ Open up the executable in an editor, there may be strings in there that indicate which compiler was used, then you can search for info on its file formats. If it's a DOS application, there's a good chance it was either Microsoft or Fujitsu COBOL.

4/ Consider placing job requests on work sites like elance or rentacoder; I don't think there's a cost if the work can't be done successfully.

5/ Hire someone to examine it and advise on the likelihood of recovery.

6/ Get a screen dump of the record contents for every active record and re-construct it from that.

Some of these are pretty hard so your mileage may vary.

Good luck.

paxdiablo
+2  A: 

I have successfully read some of the dat files using http://www.cobolproducts.com/datafile just now which I came to know through another forum. Most probably I will work with them to help me read the rest of the files that I am having an issue with.

Sudeep DSouza
A: 

I have read COBOL DAT files only with FD, when I do not have the FD, I open the file in a Text Editor, and try to guess the columns, and try again, until I have this working, the big problem with this approach is when the DAT file have COMP columns, that can be any kind of COMP type, but with a litthe patience I cold get this done.

I had tryed Parkway ODBC, but without success.

Cesar Romero