Hello,
I am looking to create an audit trail for records that have been appended or updated by a batch import. I have two queries, one that updates records from an excel spreadsheet with a unique ID already in the table and one that adds new records. I would like a table that tracks what records and fields were updated and what records and fields were appended.

My import is vba driven and dumps the spreadsheet into a temp table, runs the update and append, then deletes the records from the temp folder. I have seen a lot of examples on how to create an audit trail when a form is being used, but none when a record changes via an update or append query.

Any help / suggestions / samples / ideas?