duplicates in excel/access - Tilted Forum Project Discussion Community

metalgeek · 10-11-2004, 08:38 PM

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)

ibis · 10-11-2004, 08:52 PM

Quote:

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)

Hey, I remember you. You're the guy that has the v1agra for sale, aren't you?

oiekeooiyw · 10-11-2004, 09:11 PM

a quick access query for dups will do it. i used to have a saved query like this, but i haven't used it in years.
basically you set up your excel sheet in Access and then run a query against it that shows the unique records based on a field. that is your 'clean' list.

Twizted · 10-11-2004, 09:13 PM

In Access, you can write a query to select distinct records, it will pull only one of each value. In Excel, you can do something similiar, but I can't remember off the top of my head.

The help files in each app will give you details.

Jason

10-11-2004, 08:38 PM	#1 (permalink)
metalgeek Insane Location: Calgary	duplicates in excel/access 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)

10-11-2004, 09:13 PM	#4 (permalink)
Twizted Insane Location: Washington State	In Access, you can write a query to select distinct records, it will pull only one of each value. In Excel, you can do something similiar, but I can't remember off the top of my head. The help files in each app will give you details. Jason __________________ A computer once beat me at chess, but it was no match for me at kick boxing. -- Emo Philips

10-11-2004, 09:11 PM	#3 (permalink)
oiekeooiyw Insane	a quick access query for dups will do it. i used to have a saved query like this, but i haven't used it in years. basically you set up your excel sheet in Access and then run a query against it that shows the unique records based on a field. that is your 'clean' list.