I need to convert a number of flat fixed format ACSII files to MS Access 97.
These flat files have been converted from a legacy COBOL database running
under HP UNIX.
I can convert those flat files whose data format is only of the type X
(string data) either with MA Access 97 Import Wizard, or Data Junction.
However, the data structure of many of these flat files contains numeric
data in the P, Z, J format, as well in the X format. The structure of such
files does not layout properly against data, and I have not been able to use
either MS Access 97 Import Wizard or Data Junction to clearly separate the
fields, and perform the conversions.
I would appreciate it very much if someone out there could suggest a
strategy to handle this conversion problem. I have no experience in
programming in COBOL.
Thanks a lot in advance.