Syntax Error From Clause (1 Viewer)

[Jakboi]

Hello,

Found this here and was trying to do the following. Delete rows in my table that are dupicates and put them into a new table.

Keep getting a syntax error.

SELECT DISTINCT * FROM tblRaw INTO tblClientcontacts

Anyone know why?

I have a table that has 12,000 rows. Out of those rows are 1600 uniques. I need to delete all the duplicates. Is this a way to do it?

Thanks.

 

[Jon K]

SELECT DISTINCT * INTO tblClientcontacts
FROM tblRaw
.