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

Do all the tables have the same fields?

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

yes they do, thanks