>>>Is there any way, I can access Data from Cobol Files,
>>>
>>>we have a very old FA Applications built in cobol....
>>>
>>>Is there any way I can open it in VFP/Excel..
>>>
>>>Any hints/ideas abt cobol file structure(s) will be very helpful...
>>
>>Vinod,
>>Cobol is usually stored in fixed-length field files (SDF). There is a utility available in the 'files' section that converts SDF to DBF files.
>>
>>Good luck
>
>Thanks for your reply...
>
>Can you pls give me in which section that utility is and what is the name of file as I'm not a premier member and unable to search in file section..
Vinod,
Sorry it took so long to respond. I actually found SDF2DBF in Malcolm Pitcher's FoxPro I/O. However, if you know the names, field lengths, and field types of the Cobol file, you cand create a table in VFP, download the Cobol file, and do an "APPEND FROM
TYPE SDF. I have used it myself several times and it works quite nicely.
Good Luck,
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!