How would I pass the results of a Passthrough Query into a table?

[Jim]

I have a passthrough query that that I created through code and when I
execute it via docmd.OpenQuery I can see the correct results. How would I go
about getting this data into a table I have built through VBA?

 

[Al Campagna]

Jim,
Not sure what you mean by...
Change your pass-thru query to an Append (if you already have a table),
or a MakeTable query.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Douglas J. Steele]

Not sure that's possible, Al: remember that the pass-through query runs on
the server, so it knows nothing about the tables included in Access.

I believe you need to create the Append or MakeTable query as a second query
based on the pass-through query.

 

[Al Campagna]

Right you are Douglas. I should have said... "use the pass thru to create
an Append or Make Table."
Thanks for catching that...
--
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."