Copying distinct rows from one table to another
If they are true EXACT duplicates, you can do:

SELECT DISTINCT *
INTO NewTable
FROM Sourcetable


If they aren't exact dupes in every single field, then we need more info.