How To Merge 2 Tables Into One

[witam]

I have two tables in the same database that I would like
to combine together. How do I do this? If I use
the "export" in "File" it replaces the other table. What I
want is to merge the two tables to one.

 

[Joseph Meehan]

Assuming the two tables have the same structure, then you create a query
of the table you want to add to the other. Next with that query open in
design view, click on "append" tell it what table you want to append to and
then run it.