Need to delete duplicates in a table

  • Thread starter Thread starter smduello
  • Start date Start date
S

smduello

I have an access table that has over 470,000 rows. I need to delete
the duplicates. None of the "append" query ideas will work as it
involves copying and pasing the structure, and Access won't allow me
to copy 470,000 rows. Does anyone have a suggestion on how to
accomplish this?
 
Smduello,

As far as I know, there is no limit to the number of records that can be
entered via an append query, so I am not sure what your concern is.

If you open the table in design view, and do File|Save As... you will
get a copy of the table with no records.

Then, just make an Append Query based on the existing table, to run the
data into the new table. In the query properties, set the Unique
Records property to Yes.

After running the append, you can delete the existing table, rename the
new one to the old name if required, and there you go.
 
Back
Top