Originally Posted by metalgeek

I have some data (16k records)
however, around 9k of them are duplicates.
I need to remove the duplicates, without deleting the origionals.
Or to explain it a diffetrent way, I have 16k records each with one email address, some of the records have the same email address. I only need one copy of emach one.
How can I easily remove the duplicates fusing access or excel? (I only have 97)