I am using Docmd.Transferspreadsheet to append a large Access table with a data from an Excel table. Once duplicate values are recognized in any field that should hold unique values I would like to initiate an event that opens a message box that says something like,"Records that Microsoft Office Access was unable to paste have been inserted into a new table called 'Paste Errors.' and have that action performed. Can anyone help me with this?
Last edited:
