I have a DataTable with columns that match my Access table.
Now, I try to use the Database - Insert activity to insert this DataTable into the Access table.
The error that comes back is as follows:
Access Form - Syntax error (missing operator) in query expression
The thing is, when I debug the OleDB driver, I can see that UIPath does not put square brackets around the column names when inserting the data. This is required when having spaces in the column name.
This should be a bug report and I would like to see it fixed, or know a workaround for it.