How to transfer Progress DB into MS Access

[shivap]

I would like to transfer a Progress DB into MS Access format. The DB size is about 800 MB with 25 tables.
Any suggestions?

 

[Guest_imported]

Yeah - Dump most of the data, or import the table layouts empty, then fill the data later. I exported to Dbase and then pulled the tables in....

 

[ihda]

There is a product called DataJunction (800-580-4411) that allows you to pull data into other database formats. You would need a Progress ODBC driver. Merant (919-461-4235) is the ODBC software supported by Progress. I have pulled Progress data into Access 2/ 97/ 2000 using DataJunction.

DataJunction works, but I don't think you would be able to use it in a batch mode. Most likely you would need to convert one table at a time. I don't know if that fits your need.

If you have the ODBC drivers you can also link Progress tables into Access.

 

[Amiel]

Based on my limited exposure to Progress. There is a utility called sqldump.exe that will dump a tables contents to a delimited form. I discovered this after writing a one function utility to dump Progress tables (using Access and ADO). Never did get, 'sqldump.exe', to work by the way.

Most of the tables were 'exported' to delimited text without difficulty using a single function in VBA. One or two tables records got mangled %-( by the ODBC driver and were useless, some 'quirk' related to translating numeric data types using ODBC connections.

...use VB, or VBA.

Amiel
amielzz@netscape.net