Can The Results of a Query Be Exported/Saved to a Table

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

Didn't know if I should put this here or in the tabledesign group. Can I
save the results of a query into a new table thereby creating a new table?
If I select save as it gives me choices of query, form or report. If I
select export I don't see that choice. Am I just out of luck in wanting to
do this?
 
See Make-Table Query in the help file.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
In query design mode, click on the Query menu, select
Make Table Query.
In the popup window that appears enter the name of the
new table and click OK.
When you run your query it will automatically put the
results of your query in the new table.

Be aware that ever time you run the query it will make a
table of the same name, so you will get error messages
propmting you that you already have a table of that name
do you wish to overwrite? Do not be too quick to answer
this if you may have changed the query slightly to give
different results, and you need to keep the original
results as well.

Brian

Please reply to newsgroup.
 
Great that's exactly what I wanted to do. It also allowed me to get the
delete query I've previously asked about working. I was trying a query on a
table to identify items I wanted to delete. It wouldn't work. I now have a
quick two step process. Run the make table query which identifies the
records to delete and puts it in a query. Then a delete query takes it from
there and deletes them.....perfect.
 
Back
Top