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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Doughnut Chart linked with the slicer in the pivot table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to automate update on weekly reports spreadsheet 0
Setting column width in a table with a macro is not working 0
Help creating a search form in Access XP 0
Mail Merge file containing a Word Table 0
Creating a Chart on form from selected data in query. 0

Top