viewing duplicates in 2 tables, then appending

D

Dawn

I want to take records from 1 table and compare them with another table to
see if duplicates are present. I want to be able to delete them manually one
by one and then append what is left with the 2nd table. I have created
several queries and views but none have allowed me to actually delete
anything. Is there something Im forgetting to do?
Example: Table 1 is my new imported table with 50 records. Table 2 is my
"master" table w/ 100K records. I want to append Table 1 to Table 2, but do
not want to bring in any duplicates, so I want to VIEW any possible
duplicates and be able to delete them BEFORE I do the append query to Table 2.
 
D

Dawn

I did the Find Duplicates wizard..this was how I was able to view what were
duplicates, however this is where I could not delete any records because
there were 2 tables involved in the view! (Im assuming this)
 
D

Dawn

Unfortunately, no, there is no primary key due to there being NO fields that
are complete unique.
 
D

Dawn

Sure,
Source, Fstname, Lstname, company, street, add1, add2, dept/mailstop, city,
state, zip, zip+4, country, date, phone, fax, email, sent date, active, last
modified, notes

These are the same for both tables.
 
D

Dawn

Im not sure I understand what you are asking. Yes, a record can have dup
fields and yes, dup records might be the same person. That is why I want to
view them so I can compare and delete the one that either is outdated or has
less information.
 
D

Dawn

To answer your question, they MIGHT be the same person, What I would need to
look at to determine this is their address/company. (I hope this answers your
question).
 
D

Dawn

I am kind of dealing with this in another way, which I know is taking me ALOT
longer. I basically just brought everything into ONE table and am going
through it manually, deleting the dups. The thing that really stinks is I
have over 10K dup records to go through and only a couple of days to get it
done. I wish there was an easier way but I dont think there is.

Thanks for your help though.
 
Top