Can pass through query make table ?

[adnancanada]

I have pass through query running fine. it is giving me records but I want those record to save as table in access. How can I do it

[aytee111]

Create a make-table (or append) query and use the pass thru query as the source of the data.

[adnancanada]

Create a make-table (or append) query and use the pass thru query as the source of the data.

Thanks I used it as source table but it took me 20 minutes to create that access table. My link table has huge data in it. Any other way ?

[aytee111]

You say that the pass-thru query was working fine, how long did it take to run? How much longer is the make-table taking? It should be the same amount of time.

Is there any way that you can restrict the amount of data you are looking at? That will help cut down the time.