delete duplicate phone numbers from column, please asap

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a file of over 30,000 duplicate phone numbers i want to leave just one
of the duplicate phoen numbers and delete the rest of the duplictae phone
numbers

someone please help asap?
 
i have a file of over 30,000 duplicate phone numbers i want to leave just one
of the duplicate phoen numbers and delete the rest of the duplictae phone
numbers
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You don't describe the table the phone nbrs are in, that would help to
design a query to get rid of them....

You could just pull them out of one table & put them in a new table; use
a make-table query like this:

SELECT DISTINCT phone_number INTO NewPhoneNumbers
FROM PhoneNumbers

The new table "NewPhoneNumbers" will not have any duplicat
phone_numbers.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRFvtIYechKqOuFEgEQIpWQCgx8lIRS2X0ZUL59eCCp+VfaPGC28AoNdo
R0QABwKfmXXGIBnpt9rGOE1u
=oi1A
-----END PGP SIGNATURE-----
 
Back
Top