Union Query to a Table

I created a union query. How do I get the output to go to a new table?
Do I have to CREATE TABLE then use all the INSERT INTO functions or is there
an easier way to do this? I am creating a new table because I need another
database to be able to link to this table.

miss_mas wrote:
I created a union query. How do I get the output to go to a new
table?
Do I have to CREATE TABLE then use all the INSERT INTO functions or
is there an easier way to do this? I am creating a new table because
I need another database to be able to link to this table.

That's probably the appropriate way if you wish to have keys (indexes),
validation rules, etc.

If you simply wish to have a heap of data, then this should work (it works
in SQL Server anyways):

select column_list into newtable from ...
union
select column_list from ...
etc.


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Create the table first with the correct field types and lengths. Make Table
queries make assumptions and use defaults that waste memory space.
Create an append query that appends the output of your Union query to the
new table.
--
Dave Hargis, Microsoft Access MVP


"miss_mas" wrote:

I created a union query. How do I get the output to go to a new table?
Do I have to CREATE TABLE then use all the INSERT INTO functions or is there
an easier way to do this? I am creating a new table because I need another
database to be able to link to this table.

Thanks, this helps a lot!