How To Merge 2 Tables Into One

  • Thread starter Thread starter witam
  • Start date Start date
W

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.
 
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.
 
Back
Top