EXCEL- merged data files - keep the record which is not a duplicat

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I merged 2 data files. One has 3400 records, the other 2200. I just want to
keep the 1200 records which are not a duplicate of the other. How do I do
that?
 
Seelct the table an dpress Ctrl+C to copy it. Click a blank area in the
database window and press Ctrl+V. When the dialog box opens, select structure
only.

Open the new table in design view and select enough fields to make a record
unique and make those the primary key.

Append the records in the other 2 tables to the new table. Some will fail to
append. Those are the duplicates. The unique ones should append OK.
 
Back
Top