Save Results of Pass Through Query to Access Table

[cghoga]

How would I take the results from a table created via a pass through query and save them to a table in Access?

I have a pass through query that seems to run fine. The last step, a temp table called #Final is created and I would like to get #Final to a table I have created on the Access side.

Any help is greatly appreciated.

Thanks,
Cary

 

[jeisch]

Try creating another query using the pass through query as input to that query. That query will now be an Access query, and you should be able to do a make table or append into an Access table using that query.

 

[IT4EVR]

You need to make this a global temp table to access it from Access.

In your stored procedure create a table ##temp.

Then maybe in one query you do this(query1):

SELECT *
FROM ##Temp;

You need to make a second query

SELECT * INTO yourtable
FROM Query1;