Merge 3 Exact Tables into One Table in Access
This is probably the simpliest of questions. I have 3 tables that are the exact same, just with different data in them. I need to combine the three into one table. I do not know how to do this and I continue to get a syntax error in FROM clause. Here is what I have done.
Created the following append query:
INSERT INTO [EQ ONLY ALL DATA]
SELECT *
FROM [EQ ONLY THE DATA]
INSERT INTO [EQ ONLY ALL DATA]
SELECT *
FROM [EQ ONLY AU & IT & MX & TA & PR]
INSERT INTO [EQ ONLY ALL DATA]
SELECT *
FROM [EQ ONLY CN,CL,HK,SA,MO,PT,SW,RO]
Created the following append query:
INSERT INTO [EQ ONLY ALL DATA]
SELECT *
FROM [EQ ONLY THE DATA]
INSERT INTO [EQ ONLY ALL DATA]
SELECT *
FROM [EQ ONLY AU & IT & MX & TA & PR]
INSERT INTO [EQ ONLY ALL DATA]
SELECT *
FROM [EQ ONLY CN,CL,HK,SA,MO,PT,SW,RO]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER