Linked table query

  • Thread starter Thread starter Striker3070
  • Start date Start date
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?
 
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
 
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
 
Back
Top