Just Confused

[BigCat]

Right now I have run a query in Access 2007 on my SQL Server database and gotten a ton of results. Now I need to pull only a few columns from my big query and stick in an Access table, but I just can't figure out how to get it done. Please help for some reason I am just totally stuck right now.

[jzwp11]

I would create a new query that is exactly like the query you already created. Then edit the SELECT clause of that new query to only include the fields (columns) you want to put in the Access table. Now do you already have the table created in Access or not?

If so, you can take the newly created query and change its query type from SELECT to append. When prompted, identify the table to which the data should be placed and then match the fields in your query to those in the new table and then run the append query.

If you don't have the table created, take the newly created query and change its type to Make Table query and run it. Access will prompt you for the new table name.