How to save a query as a table

[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

 

[Wayne Morgan]

Use a Make Table query.

Example:
SELECT Table1.* INTO NewTableName
FROM Table1;

 

[Joseph Meehan]

Hi

How do you save a query result as a table in a simple manner?

Normally you would not want to do this. Normally you would just re-run
the query. Don't store data twice.

As already noted you change the query to to a make table query.

 

[Asmodeus]

How do you save a query result as a table in a simple manner?

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