tracking duplicate information in access

[Guest]

I am trying to create a data base with information imported in from excel in
to an existing table. I want to identify information in two way. First who
has been added to the table that was not origionally in it. Second who is not
in the imported information form the origional table.

 

[Michel Walsh]

Hi,


You may start with a run of the query wizard about finding unmatched
records (records in TableA not in TableB), before you append records, from
Excel.



Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

Michel do you mean that I query the excel or the table in access before I
append

 

[Michel Walsh]

Hi,

I would link to the excel data as a table, or import the data in a temp
table, then run the Unmatched query with this temporary table and compare
with the table having some data. That second table is also the table that
will receive the data from the temporary table, further on.



Hoping it may help,
Vanderghast, Access MVP