How can I prevent duplicates when importing data???

[Vol]

We have a large database of about 400,000 names. I need some information re: the easiest way to import new leads (usually around 20,000) and eliminate any duplicates that may already be in our database [sig][/sig]

 

[MichaelRed]

Vol,

I usually import new info into a temp table, "groom" the new info to match the table which will receive the new data. This process can include checks that prevent duplicates. In the last few steps, have/create a query which checks for duplicate entries between the new and current tables (Ms Access has a wizzard for this, if you aren't comfortable with 'rolling your own'). Use the recordset generated by this query to filter the new data from an append query.

[sig]<p>MichaelRed<br><a href=mailto:mred@duvallgroup.com>mred@duvallgroup.com</a><br>There is never time to do it right but there is always time to do it over[/sig]