Insert using Select

[mjlong999]

I would like to perform an insert based on a select statement. The catch here is that I would like to insert the records using a pass-through query, where the select is based on a table from the Access database.

For example, a pass through query like this...

insert into OracleDB.table1(cola) (select colb from Access2000.table2);


Is this possible with Access 2000?

Thanks for taking the time....

mlong

 

[mpastore]

I don't think this is possible as a pass-through. You need to link the Oracle table into access then you can insert the records to the linked oracle table.

You could build dynamic pass-through insert queries but you will have to specify the value list and run a loop to get all records in one at a time.

 

[mjlong999]

Any chance XP Access has this functionality?

Thanks for your help.

mlong

 

[mpastore]

I doubt it because if you think about it, Oracle would need the ability to reach "back" to your client PC in order to join its tables to your local MS Access table. This would in fact make your client PC a "data server" of sorts.

Mike Pastore

Hats off to (Roy) Harper