Removing duplicate records Excel/Access..

[Joebob]

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.

 

[HeX]

How are the records stored? Is it just row after row in excel? Are the duplicates identical?

If so you can just use Advanced Filter, by Unique Records, then just copy and paste the filter list.


If it's in Access then there's a good set of info here:

http://office.microsoft.com/en-us/a...icate-records-in-access-HA001034558.aspx#BM15

 

[Makhaira]

Stick it in Excel, go to Filter, Advanced Filter, and select Unique Records only. Then just copy the displayed data elsewhere, job done .