How to save a query as a table

S

Sharp

Hi

How do you save a query result as a table in a simple manner?
Conventionally, I would do the following:

1. Select all data and paste into a text file, and then import the text file
as a table.
or
2. Export data into a text file, and then import the text file as a table.

Cheers
Michael
 
W

Wayne Morgan

Use a Make Table query.

Example:
SELECT Table1.* INTO NewTableName
FROM Table1;
 
A

Asmodeus

How do you save a query result as a table in a simple manner?
Click to expand...

Click Query, Make Table Query, give the table a name and run it.

--
"It's better to be a red person in a blue state than a blue person
in a red state. As a red person, if your blue neighbors turn into
a mob at least you have a gun to protect yourself. As a blue person,
your only hope is to try to appease the red mob with herbal tea and
marinated tofu."
--Phil Garding
 
Top