21 Feb 2012 at 09:48 #1 Joebob Joebob 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.
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.
21 Feb 2012 at 12:04 #2 HeX HeX Soldato Joined 20 Jun 2004 Posts 12,023 Location Huddersfield, UK 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
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
21 Feb 2012 at 12:19 #3 Makhaira Makhaira Soldato Joined 23 Nov 2007 Posts 4,994 Location Lancashire, UK Stick it in Excel, go to Filter, Advanced Filter, and select Unique Records only. Then just copy the displayed data elsewhere, job done .
Stick it in Excel, go to Filter, Advanced Filter, and select Unique Records only. Then just copy the displayed data elsewhere, job done .