viewing duplicates in 2 tables, then appending

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

Guest

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.
 
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)
 
Unfortunately, no, there is no primary key due to there being NO fields that
are complete unique.
 
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.
 
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.
 
I guess what I was trying to convey is this:

Person Name Send Date Last Modified Notes
---------------------------------------------------------------------------------------------------------------
John Doe 1/1/2005 1/10/2005
Likes donuts
John Doe 1/1/2005 1/12/2005
Likes coffee


Would these records be considered the same person?
Visually, yes.. they would. However, the records do differ.

What I want to make a distinction is that when you say duplicate records,
its across ALL the fields.



--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com
 
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).
 
Dawn

I realize this conversation has carried on for a bit and we have not really
gotten to a possible solution. I want to know if this is still an
outstanding issue for you. If so, I'll see what I can do to help assist you
with completing it.

Please let me know.
--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com
 
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.
 

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

Problem With Autonumber & Append Query 2
Append only Null records in table 2
Append Query 3
Append Query Issue 0
update a secondary table based on the master table 3
how can I eliminate the warning message in an append query 2
Appending records 1
Append Copy of Table 9

Back
Top