Access query to oracle view tool

[zaman1111]

We have a Access Database which creates forms and reports. It has lots of queries. we want the similar funtionalities in Oracle. Is there any tool that will convert these access queries to Oracle views. I used Migration workbench to convert the database but it can't convert the query.

[gandolf989]

I would want to rewrite the queries because I don't like the way that Access writes queries. If you find someone that is capable of rewriting the queries in Oracle, than they can tune them at the same time.

You may want to find a better front end than Access though.