Append only new values-

  • Thread starter Thread starter Karl Thompson
  • Start date Start date
K

Karl Thompson

Is is possible to write an append query that appends into table B from table
A only those values missing in table B without Access raising an error about
not being able to append all records due to key violations?

I'm trying to avoid an initial query that would query out the missing keys
from table A and then appending them using a second query.

TIA
 
Something like:

INSERT INTO tblB (FieldsFromTblB)
SELECT {FieldsFromTblA}
FROM tblA LEFT JOIN tblB
ON tblA.UniqueField = tblB.UniqueField
WHERE tblB.UniqueField Is Null

HTH
Van T. Dinh
MVP (Access)
 
Back
Top