how do set up a delete query on one table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have imported an excel spreadsheet with thousands of duplicate entries
which i need to filter out. How do I do this in access?
 
I have imported an excel spreadsheet with thousands of duplicate entries
which i need to filter out. How do I do this in access?
Click to expand...

There are several ways, but probably the simplest is to create a new
table with a unique Index on the combination of fields which define a
duplicate. Run an Append query from the imported (or linked)
spreadsheet into this table; only the first instance of a duplicate
will be stored, the rest will be rejected with a warning message.

Note that this will only catch EXACT duplicates. If you have records
that are *almost* duplicates (e.g. one record has "312 Main St.",
another has "312 W. Main St.", and a third has "312 Main Street" these
are NOT duplicates), you've got a lot more complex job to do.

John W. Vinson[MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use Save As or Save Query? 2
Table cleanup 3
Query Delete Duplicates 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How do I unLINK a table in Access? 2
Delete Duplicates Query 1
Filtering an append query 2
Self joined table in a delete query 2

Back
Top