Large rowset

[Richie Rich]

I have a table(7 fields) which contains around 100,000 records. Within these
100,000 records, I know there are many duplicated rows. I have sample data
of around 10,000 records.

I have wrote a query to find out how many duplication I have:

SELECT [Find duplicates for Training_History-1].*
FROM [Find duplicates for Training_History-1] INNER JOIN
[Training_History-1] ON [Find duplicates for Training_History-1].[Learner
Field] = [Training_History-1].Learner;

Then I have wrote a distinct query to clean it up further:

SELECT DISTINCT [Find duplicates for Training_History-1].*
FROM [Find duplicates for Training_History-1] INNER JOIN
[Training_History-1] ON [Find duplicates for Training_History-1].[Learner
Field] = [Training_History-1].Learner;

This has de-duplicated the duplicated row set of 10,000 (sample data of
100,000)

Now I would like to update the orginal table with this clean data...???

Any ideas...?

Note****
There is no PK or no indexing what so ever on the table, and I HAVE to check
each and every field for duplication.

Please help me. I need to sort this out

 

[John Spencer]

If you are simply trying to get the unique records in the table why not use
SELECT DISTINCT *
FROM [Training History]

If you really need that in another table then you could copy the stucture of
your current table and turn the above into an append query. That should
give you a table with just the unique values. Then you can rename the table
(after checking it) to the original name. Then I suggest you will want to
compact your database to recover the space.