I have too tables: tblFinal and tblRaw in Access, and want to update tblFinal with the newer (not necessary better) data in tblRaw.
In the tblRaw, I have: (1) some new records which I definitely want them to go into tblFinal; (2) some old records (already exist in tblFinal) which I want either to update or ignore, depending on my judegment.
If I use SQL:
SELECT tblRaw.* INTO tblFInal FROM tblRaw
Access will give a warning message: " ... n records cann't be appended because of key violation ....".
My question is: Is there an easy way to get a subset of these n violation rescords? With such a subset, I will be able to delete those records I want to ingore and update tblFinal with all of rest.
In general, I am looking for a way to get the set of violation records whenever Access gives a warning message of "key violation", instead of just knowing the number of records causing the violation.
Many thanks in advance.