Remove duplicates in Access 2003 database

[stainless]

For reasons too complicated to go into, I have an access database with
23 columns and no primary key.

Thus this is really a list of data that is not behaving as a proper
database.

It is a huge table (2 million rows) and some rows have been
duplicated, due to a bug in the population process. This means there
are rows that are repeated in their entirety.

We need to quickly remove these duplicate rows so only unique rows
remain. There are about 4000 rows that need to be removed in this
process.

Given a table called BusinessCollections with the following columns :

Address
Postcode
Name

How do I remove the 4000 rows from BusinessCollections that are
repeated and thus, duplicated rows?

Cheers

Mark

 

[Allen Browne]

Try this:

SELECT DISTINCT BusinessCollections.Address,
BusinessCollections.Postcode,
BusinessCollections.[Name]
INTO MyDeDupedTable
FROM BusinessCollections;

 

[??F?????? ?G???]

For reasons too complicated to go into, I have an access database with
23 columns and no primary key.

Thus this is really a list of data that is not behaving as a proper
database.

It is a huge table (2 million rows) and some rows have been
duplicated, due to a bug in the population process. This means there
are rows that are repeated in their entirety.

We need to quickly remove these duplicate rows so only unique rows
remain. There are about 4000 rows that need to be removed in this
process.

Given a table called BusinessCollections with the following columns :

Address
Postcode
Name

How do I remove the 4000 rows from BusinessCollections that are
repeated and thus, duplicated rows?

Cheers

Mark

 

[viktor chuzhakin]