There is no "easy" way, unfortunately, unless you go ahead and do the
append, and then compare the table's contents to the original data source
for the records being appended. Otherwise, you'll have to do a lot of
debugging to find the records that won't append if you don't do the append
query at the time you get the error.