Duplicates

[Rogue Programme]

Hi

I have imported a 1 column table from an external source for the sole purpose of deleting duplicates. There are over 400,000 rows. What do i need to do to identify the duplicates?

Thanks

 

[Rogue Programme]

I've just found the 'find duplicates query' wizard!

 

[DanG]

That will find the duplicates but it won't delete them and leave you with the only one record of that duplicate set.
Lots of ways to do that but I think the first one I'd look into would be making a copy of your table (structure only no data) then in the new table set the primary key on the field that holds the duplicate value and make sure in the property (general tab..indexed field) setting for that field that it says "yes (no duplicates). Then append your original tables data to the new table and it should sift the duplicates for you.

As I said this is just one of many methods.

Good luck!