Concatenate two tables

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

 

[Joan Wild]

You could have used an Append Query.

 

[Walter Donavan]

Gotcha. Thanks.

 

[Michael J. Strickland]

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.