tracking duplicate information in access

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

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.
 
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
 
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
 
Back
Top