Trouble using database insert for simple Access database

Help
,
1

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?

2

Any ideas on why the insert activity isn’t working in this case?

3

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?