Combining/Merging Tables Access 2007

[lowanam1]

Hello, I have mulitple dbs that are exactly the same in design that I need to combine into one db. The problem that I am having is that the primary keys are autonumbers and I get errors when trying to copy and paste the data into the tables. Is there an easy way to combine/merge all the tables? I have attached a sample for review. Password LOCK

 

[llkhoutx]

Append the tables without the primary key. Will any of the dat be duplicated?

 

[lowanam1]

Thx, I don't know how to append properly then because I tried that. And yes some of the data will duplicate

 

[llkhoutx]

Google "Append Query" and filter out the duplicates.

 

[lowanam1]

that did it! i figured it out thx so much