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?