Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Converting a MS Access Query to Oracle SQL

Charlie (ME)Sep 26 2003 — edited Oct 20 2003
Hi,

We have a large number of MS Access (2000) queries (mostly select queries -Some containing sub queries-) that need to be converted to Oracle's syntax to be used on our intranet instead of the existing Access frontend.

Do you know of a tool that can do this?

We understand that conversion tools are not always reliable, but even if 75% of the queries are converted for us we can then focus on the ones that pose problems.

Regards,
Charles McGrotty
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2003
Added on Sep 26 2003
2 comments
753 views