Merging two tables

[Guest]

I have two tables in Access, and want to link each of them to a single table.

If I use the File, Get External Data, Link Tables option, it creates two
tables that are each linked to a single table.

One way of solving this is to do as above, and then merge the two linked
tables.

How do I merge tables?

 

[Guest]

Do the two tables have the same structure (fields and data types)?

If so, you could use an append query to append one table's records to the
other.

Steve