"append query" issues

I have the same problem. I have 70 tables that I want into one table. All tables have the same structure with different content. I tried an Append Query but got "multiple" destination message. I am stuck with the 70 tables as my source. My question is how do I merge them into one table.

Normally, you would use an append query on one table at a time.

INSERT INTO TargetTable (FieldA, FieldB, FieldC)
SELECT S.FieldA, S.FieldB, S.FieldC
FROM Source1 As S

Repeat the above for each of the 70 tables.

You can use a union query to combine multiple tables, BUT you will run into a
limit on the number of tables/fields that you can include before you get all 70
tables into your union query.

If you don't understand this, then can you post back with the SQL of the query
that is failing?

BJMLaJolla wrote:

I have the same problem. I have 70 tables that I want into one table. All tables have the same structure with different content. I tried an Append Query but got "multiple" destination message. I am stuck with the 70 tables as my source. My question is how do I merge them into one table.