Thread: Combine tables
View Single Post
  #3  
Old August 17th, 2007, 02:22 PM posted to microsoft.public.access
Al Campagna
external usenet poster
 
Posts: 647
Default Combine tables

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."

"Rose" wrote in message
news
I have two tables that are identical except they contain differant records.
What is the easiest way to combine them into one?
--
Rose