How to combine many tables into one

[zhuanyi]

Hello,
I have around 40 tables right now on hand and I would like to combine them into one big table (a table, not table formed by query) and I am wondering is there a easy way of getting it done without me physically copying and pasting all 40 tables? Thanks!

regards,
Anyi

 

[KeithG]

Do all the tables have the same fields?

 

[mhartman]

Hello:

If all your tables have the same fields, you can run an "Append Query" and attach all your tables to one table.

Regards
Mark

 

[zhuanyi]

yes they do, thanks