Combine tables

[Guest]

I have two tables that are identical except they contain differant records.
What is the easiest way to combine them into one?

 

[Guest]

use an append query but make sure you have a unique identifier for each row

 

[Al Campagna]

Rose,
Create an Append Query to add the records from one table into the other.
Make sure you backup both original tables before doing the Append.
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."

 

[Pieter Wijnen]

To view all of them
SELECT * FROM TableA
UNION ALL
SELECT * FROM TableB

HTH

Pieter