Merge Tables

[Rose]

What is the easiest ways to combine mutliple tables that have the same fields
(and no auto id or primary keys to worry about)?

 

[Allen Browne]

Use a series of Append queries to add the data from the other tables to the
one where you want it.