Create a new Table in MS Access using an existing SQL query

Question

I have two different tables US and UK in my Access database. I have imported these two tables from two different excel files. Now I am creating a query for Union of these two tables and query runs perfectly. My query is given below:

SELECT ID,Month,Year,Country
From UK
ORDER BY ID;
UNION SELECT ID,Month,Year,Country
From US;

Now I want to create a new Table where the out put of the above query will store. I want to write a SQL code for that. I am totally new in Sql so need help to resolve it.

Do UNION ALL, and skip the ORDER BY.

jarlh
– jarlh

2021-07-18 20:04:05 +00:00
Commented Jul 18, 2021 at 20:04 — jarlh
– jarlh, Commented Jul 18, 2021 at 20:04

Parfait · Accepted Answer · 2021-07-18 21:22:36Z

1

Simply run a make-table query which involves the INTO clause in MS Access SQL. Also, place UNION query in a subquery derived table:

SELECT ID, [Month], [Year], [Country]
INTO myNewTable
FROM (
    SELECT ID, [Month], [Year], [Country]
    FROM [UK]
    UNION ALL
    SELECT ID, [Month], [Year], [Country] 
    FROM [US]
) sub
ORDER BY [ID]

answered Jul 18, 2021 at 21:22

Parfait

108k19 gold badges102 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gustav Over a year ago

I would assume UNION, not UNION ALL.

Collectives™ on Stack Overflow

Create a new Table in MS Access using an existing SQL query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related