Append Querry

[ranbir parmar]

How do I append multiple tables (30 or so) into a single
table (assuming all have similar fields)?

Thanks a lot for your help. However, Append Query allows
records from one table to be appended at a time. I was
wondering if there is a quick way merging (records of) all
30-40 tables in a single step.

Regards
..

 

[Guest]

I figured it out. "UNION" operation is the answer.