Error while trying to append data to existing MS Access Database from UiPath DataTable "Insert: Syntax error in FROM clause."

Help Studio
, ,
1

Hello,

I placed data from an Excel workbook to a data table using the Read Range activity. The Excel Sheet has the same column names and data types as the Access table.

I’m getting the error “Insert: Syntax error in FROM clause” when I used the Insert activity for inserting the data table to the Access database table in UiPath.Database.Activities package.

Please share if you have had an experience with this. Would appreciate any assistance with this.

2

Can you share the insert query

3

image
image1613×318 22.8 KB

4

when you use this Insert activity, please make sure in any of the column values there are no words like ‘From’, ‘Like’ etc., basically any sql key words. If you have any, replace them with any short foms.

5

@meghna.b.das did you try the solution ?

6

Sorry for the delay in response. I got caught up with some work.
So, these are my Access and Excel table columns below -

image

image

7

The table that you´re trying to insert has spaces on its name. Instead of “ES8 Pricing Reserve Rates (ACCT)”, try to put square brackets “[ES8 Pricing Reserve Rates (ACCT)]”. Do the same if you have fields with spaces on its names.