Remove duplicate records?

[eStudio]

We have a client that has been using a different back-end for each site and we are going to integrate all sites to use the same new backend. We need to combine the email database but don't want duplicates.

How can we remove duplicates?

Thanks,
Donna

[DaveMaxwell]

The easiest way would be:
. . .[list=1][*]Load one table as the primary [*]Load the second into a holding table[*]Delete all records from the holding table that exist on the primary table[*]Insert all the records from the holding table to the primary table[*]Repeat steps 2-4 with the remaining tables. [/list=1]