Does anyone know the best way of creating a error log table containing records that have failed to append to a target table for reasons of validation? I think this must be done using vba code to loop through the source table records appending each one in turn to either the target table or to the...