November 21st, 2003, 10:51 PM
Building SQL Statement
Is there any tools to build SQL Statements from Oracle Database?
And then copy the statements from the tools and paste it on the access query to become passthrough query for use in Microsoft access which database have the table linked to the oracle database.
Thanks for your big help,
Real, Nice and Beautiful are my hungry for knowledges.
February 13th, 2004, 07:31 PM
Why don't you create an ODBC connection in Access? Import the tables you want and create the queries using Access.
Another tool for creating queries is Oracle Discoverer.