Merging two tables

S

Steven

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?
 
S

SteveM

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
 
Top