How to delete duplicate records from a table ?

I uploaded some data about 2 or 3 times and it keep appending it to the
table.

Now I want to keep only first duplicate and delete rest of.

Suppose part number 123 has been added 3 times so I want to keep only 1
record.

ThanksRefer to following url

http://support.microsoft.com/defaul...B;en-us;q139444

--
- Vishal