Query Import Problem

[BigCat]

I have a large query with over 3500 results in it that I was able to get when I connected to my SQL Server Database and query straight from that.

I now need to import about 6 of the columns from my query into a table where I can add in some extra columns that need to be entered manually. That is where I get stuck.



I cannot seem to get the columns I need into my other table.

I need the data to come from my query so when I have new data in my database I can just update the query which will update the table.

OR if that is not possibly let me know.

[orange]

In general, you would Select the fields you want from your large query and INSERT INTO your new Table. Then as a separate step you would manually add the fields you want to your New Table in Design mode. Then add the data to the new fields.

Suppose your saved large query was something like.
LARGEQuery:
Select field1,field2, field3,field4,field5,field6.....fieldX FROM SomeTable.

So to put Field2,Field5 and Field6 into your newTable

INSERT INTO NewTable (Field2,Field5,Field6 )
SELECT Field2,field5, field6 from LARGEQuery)