Append Data to a Table:
Find Duplicates Query
"There's a
Query for that!" Access has a Find Duplicates Query Wizard that will
walk you through the steps.
6.
Try it: Find Duplicates Wizard
Go to
Create->Queries->Query
Design.
Click on
Find Duplicates Wizard
Click
OK. The Query Wizard should begin.