Export Data from a Progress Database - Version 10.2b

klwn
klwn used Ask the Experts™
on
Hi - We're looking to change our current software supplier over the next 6 months. One of the tasks they've assigned us to is to export the current data into a readable format so they're able to look at the data their end.

The only option I'm aware of is to use the Dump/Reload facility within Database Administration, as I've used this on a handful of occasions to improve performance. I've looked at the dump files (.d extension) from the last dump performed & have opened up one of the table dumps within excel. I can read the data but there are no headings associated with the columns so the data is next to useless, as I can only take a guess as to what some of the columns mean.

Can you please suggest the best approach/steps for exporting data from a progress DB into something like excel/access?

Many thanks

Dax
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Download and install Progress ODBC driver and connect the Progress database from whatever you need (Excel, Access, FoxPro, etc.).  Of course, you should expect some incompatibilities but if you create a linked table in Access then you may access Progress data same way as you are accessing MS Access data.

Info about ODBC driver availability is e.g. here: https://www.progress.com/odbc/data-sources/openedge 

Based on non-Progress knowledge 32 bit drivers are better or more compatible to do this task.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial