See attached example Access database and .xaml
testRBQWeekInsert.zip (21.8 KB)
I have a table with 2 datetime fields and a number field. I am trying to use the insert activity to add a row and I keep getting a syntax error: Insert :
Syntax error in date in query expression 'Week_#'.
It seems like UiPath thinks the ‘Week_#’ field is a date, but I am just passing an integer. Any idea how to get around this issue?
Any ideas on why the insert activity isn’t working in this case?
Another bump (hadn’t touched this in awhile). I’ve discovered it isn’t working because the column name ‘Week_#’ has the special # character. I could successfully use the Insert database activity when I changed the column name to ‘Week_Num’ instead.
However, I don’t have the ability to change the production column names. Does anyone know how to escape the # symbol in a column name when using the Datatable Insert activity?