Concatenate two tables

  • Thread starter Thread starter Walter Donavan
  • Start date Start date
W

Walter Donavan

I solved this, but there has to be a better way.

I had two tables identical in format, differing only in contents. I wanted
to concatenate them. I had to export them to Excel, concatenate them (copy,
paste) there, and then import them back to Access.

Is there an easier, softer way, I hope?
 
Quick Table Append:

1. Select all records of the source table (Click upper left corner).
2. Ctl-c (copy).
3. Minimize (don't close) source table.
4. Open the 2nd table (destination) and select the add record location
(bottom left corner).
5. Ctl-v (paste).
6. Verify records have been pasted and that the fields line up.
6. Close and Save destination table. Close (don't save) source table.
 
Back
Top