auto delete duplicates

[sammiantha]

I have never used access before today and need help for work please.

I have been sent email contacts from different people in the company in a csv file and we are going to use them to invite people to like our new facebook site. However we do not want to email the same person multiple times so I wanted to use Access to put all the email address in a table and delete the duplicate ones and then turn it back into a csv file to upload to facebook. I have managed to import the email addresses and have a table of over 10000, I have done a query that shows we have over 3000 duplicate email addresses.



Now, though, I can't figure out how to delete them without manually clicking on each one.

Hope this makes sense and any help will be greatly appreciated.

It is access 2010 that I am using.

[recyan]

Do not know how things are at your end, however :
1) Before importing, can we not set the EmailID field in the access database table as primary. This will prevent duplicates from being inserted in to the table.
2) Another option, With the data containing duplicate email id's,

SELECT 
DISTINCT Table1.EmailID 
INTO 
Table2
FROM 
Table1;

Thanks

[jhargram]

you might be able to
use DISTINCT in you SELECT statement to avoid loading them in the first
place.