Removing duplicate records Excel/Access..

Soldato
Joined
27 Sep 2005
Posts
5,909
Location
Burbage, Hinckley
Does anyone know a simple way to remove duplicate records from a database?

I have nearly 100,000 records - so far too many to go through and manually remove dupliactes! There must be some automated process I can use.
 
Stick it in Excel, go to Filter, Advanced Filter, and select Unique Records only. Then just copy the displayed data elsewhere, job done :).
 
Back
Top Bottom