Merging tables

  • Thread starter Thread starter PCOR
  • Start date Start date
P

PCOR

I am in a very difficult position.
In this office TWO people are responsible for inputting data into an access
database. They both work separatly.My job is to merge both tables(called
MASTNAME) and to eliminate any duplicates.
Can any one tell me how to do this properly and quickly?
Thanks
 
PCOR said:
I am in a very difficult position.
In this office TWO people are responsible for inputting data into an access
database. They both work separatly.My job is to merge both tables(called
MASTNAME) and to eliminate any duplicates.
Can any one tell me how to do this properly and quickly?
Thanks
Click to expand...

I would use the Find Duplicates Query Wizard to create the base SQL. Link to
each of the user's tables, then run the Wizard against those two. Modify the
SQL it produces to INSERT only one copy of the duplicated rows into the main
table. Save that Query and run it each time you need to merge.
 
Back
Top