Linked table query

S

Striker3070

I have a linked table in A2007, and I can run a passthrough query and get
the data I want. However I need to copy that data into a access2007 table.
How do I add the results of the query to a access table?
 
K

Krzysztof Naworyta

Striker3070 wrote:
| I have a linked table in A2007, and I can run a passthrough query and
| get the data I want. However I need to copy that data into a
| access2007 table. How do I add the results of the query to a access
| table?


use your passthrough query as source for new query:

Insert into MyTable (...)
Select ...
From MyPassThrough

or

Select ... Into NewTable
From MyPassThrough
 
J

John Spencer

No, but you would have to specify the field names in the same order. That is
what the elipsis (...) is supposed to signify.

INSERT into MyTable (FieldA, FieldB, FieldX, FieldDate)
SELECT FieldOne, FieldXXX, FieldSomeData, FielSomeDate
FROM MyPassThrough

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Top