how can i convert a Progress database to an access database?

By blessedlady ·
we currently use Progress 8.3 and i need to have my database converted to access or even excel to generate some other reports. apparently there's some problem with the 2010 date and i cannot generate reports for this year in that system. I desperately need some help with this.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Wow, someone else that uses progress!

by Charvell In reply to how can i convert a Progr ...

I never thought I'd find someone else that uses progress.

I've never done an actual database conversion, but I do have a simple section of code you can use to basically create a .csv file of the data you want, which you could then use excel to manipulate, would that be helpful?

Collapse -

surprise! yeah we seem to be a small set dont we

by blessedlady In reply to Wow, someone else that us ...

yes, i think that would be helpful. thanks a lot

Collapse -

Here you go

by Charvell In reply to surprise! yeah we seem t ...

out put to {file location}/{filename}.csv
for each {tablename} where {conditions} no-lock.
export delimiter ","
{as many fieldnames as you need}.
output close.

Hopefully this makes sense to you. NOTE: We are on Progess 9.1E, but I'm pretty sure the syntax should be the same.

Collapse -

We just upgraded to Progress 10

by oldbaritone In reply to how can i convert a Progr ...

and I still don't understand why.

Things would have been so much easier on Oracle or even MS-SQL.

It's not easy to get the ODBC connection to Crystal Reports to work reliably. It sounds like you're having some of the same issues.

Related Discussions

Related Forums