Using Pass Through Queries to populate local DB

[alanponeill]

I am trying to use a Pass Through Query to process a select statement on a remote database. I want to then pass the contents of that query to a table on a local database. I have to Pass Thru working fine but cannot populate it to a local table, how should I proceed.

Thanks,

Alan

 

[Norie]

Can you not create a make table or append query based on the pass through query?

 

[alanponeill]

Afraid that the inclusion of the Pass Thru query into the design view Append Query does not work.

Anyone else got any ideas

 

[Norie]

Does the query actually return records?

 

[alanponeill]

Yes

 

[Norie]

Can you add it to a normal query?

Check out Access help on pass-through queries it has stuff about making tables from them.