combine Pass-through qry(Oracle syntax) and make tbl qry??

[hengsin]

as i understand, if i want to build up a new table using query, i can put the

INTO tblName somewhere in the query to build up a new table.

Now i'm writing the Pass-through Query to obtained the data from Oracle database. So, i need to use the Oracle-syntax to write out the query.

Next, i want it automatically to save query result into a new table. How can i do it?

 

[dhookom]

Create a make table query based on your saved Pass-Through query.

Duane
MS Access MVP