Question Locked

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

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

5 replies

by charvell

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?

by charvell

out put to {file location}/{filename}.csv
for each {tablename} where {conditions} no-lock.
export delimiter ","
{as many fieldnames as you need}.
end.
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.

by oldbaritone

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.

This discussion is closed to new replies.