I’ve created a process which extracts data from an email using Regex and the Assign activity. Each variable is then added to a data row using the ArrayRow input and added to a data table.
I am then opening Excel and using the Append Range activity to paste the DataTable data into the sheet. From there I am copying the data (Select Range, Copy Selected Text, Set to Clipboard) from Excel and pasting it into Access (Control + V).
I was wondering if there is a way I could bypass the MS Excel step of this process and just paste straight into the MS Access table?