Append only new values-

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
 
V

Van T. Dinh

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)
 

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

Top