Converting Access queries to ANSI SQL

[Quoted] I am currently converting a MS-Access database into Oracle. I am having a problem with re-writing all the MS-Access queries into ANSI SQL for the Oracle version of the database. The problem is two-fold.

Firstly it is taking a long time having to manually re-write the queries.

Secondly I am having problems re-writing some of the more complex joins that are in Access into Oracle - this is due to Access's Jet Engine DB having INNER, LEFT and RIGHT Joins - I understand what these joins are and I am having success in translating them into ANSI SQL but I am not confident when it comes to complex nestings of these joins.

So basically is there any software that can translate Jet Engine DB queries (Access queries) into ANSI SQL? Is there any definitive help in terms of guidlines for translating them? Basically help! I have been trawling through books and help files and all to no avail (and if anyone suggests trying exporting the queries from Access via ODBC into Oracle then please don't as I have already tried - it doesn't work - Access runs the query first then exports the resulting table)

I hope someone can help

Regards
Tim Nutman Received on Wed Feb 12 1997 - 00:00:00 CET