Sorry I was so slow getting back to you. Here is a an insert query we used on an access database. It was contained within a ‘For each row’ loop to insert 1 row at a time as that was we had issues that were hard to debug (probably Type issues) when trying to insert the uipath table into the access table in one single insert statement.
Notice how all the column names are surrounded by [square brackets] - this tells the query that it is a literal and so it treats things like spaces, #, and other symbols as text as long as it’s contained in the brackets
"Insert into Review_data
[Transaction complete date],
[Line of Business],
[Transaction receive date],