Append/Update Query: If fieldname is null then update

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

Guest

I know this has been asked before but I couldn't find a question that matched
mine. Here's the process, I download an Excel sheet that I then import to
Access as a table. I then need to append the Excel information (T1) to
another table (T2). T1 contains past records as well as new records. I need
to append the new records from T1 without adding the old records. I think
I've done this before by setting a property to unique records (or values) but
I can't remember where to set that property and, of course, asking a simple
question through MS help yields every response except the one I need.
Thank you.
 
To do this, you must have some way of identifying which are the new records.

If you have a CustomerID column, then you want to add the values that are
not already in the target table. You can do this by creating a new query. In
the first dialog, choose the Unmatched query wizard. After running through
the wizard, switch the results to an Append query (Append on Query menu.)
 
Back
Top