Stay informed about any major changes. Click here to subscribe
Delete duplicate records from a table
Deleting duplicate records from a table requires two steps. First, you
create a copy of the structure of the table that contains duplicates,
and then make primary keys of all the fields that contain duplicates.
Second, you create and run an append query from the original table to
the new table. Because fields that are primary keys can't contain duplicate
records, this procedure produces a table without duplicate records.
This is the logic behind the Remove Duplicate Records tool. It creates
mentioned actions in the background and allows you to select which columns
in the table should contain unique data.