Accessing Access tables from Microsoft COBOL 5.0 2

[SteveMillman]

Does anyone know how I can possibly read our Access database's tables in COBOL? I would like to be able to process them as I would COBOL to assist us in a migration we are making to a new platform.

If I could output files that could be read and imported into SQL Server, all the better.

There needs to be a lot of massaging of the data before it makes it into the final format.. so I thought COBOL might hold the power to easily manipulate the data in question.

Any serious clues?

Thank you,

Steve Millman

 

[Crox]

Hi Steve,

If you export Access into DBF for example, I can help you with a DBF reading routine for CA-REALIA and MF.

I also have a generator for working-storage definitions out of DBF.

Other readable files are CSV formats.

Regards,

Crox

 

[SteveMillman]

Crox,

That would be great. I could export the tables to dbf format easily and would be interested in trying out those routines against the dbf formats.

I'd appreciate if you could email them to me.. my email is Steve@miscs.biz

Thanks a lot,

Steve

 

[gregsimpson]

Steve,

alternatively you could try accessing the database through the COBOL with an ODBC connection/driver.

Greg

 

[SteveMillman]

Greg,

I will have to investigate that. Seems there is a lot for this old mainframer to pickup to play with these two platforms simultaneously.

Thanks,

Steve

 

[Crox]

Hi Steve,

How are things going?

Regards,

Crox