Incorrect syntax near ‘Check’ when using Insert Data Table

Help Activities
, ,
1

Hi Team,

From Webpage, I am trying to extract the table data using Extract table data activity and inserting the table to database using insert activity. During runtime, when inserting I get an error:

Insert: Incorrect syntax near the keyword ‘Check’.

the word ‘Check’ appears in one column value named ‘Check’. Does anyone have any idea what might be causing this error?

Column name is same as in database table. In table setting the column name is mentioned inside single quotes ‘xxx’.
please help.

2

Hi @Nancy29

instead of writing the query like this:

INSERT INTO table_name (Check) VALUES (...)

You can try:

INSERT INTO table_name ([Check]) VALUES (...)

By enclosing the column name in square brackets, you can avoid conflicts with reserved keywords.

Make sure to update your UiPath workflow accordingly with the modified column name or SQL query.

Thanks!!

3

Hi Nitya,

Thanks for your reply.
I’m not using sql query. I’m using the insert data table activity for inserting the extracted table data to database table.
Could you please suggest on this.

4

My column names were mismatching which is causing the above error. it is sorted out .Thanks.

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.