I am trying to insert into a local database. I have the database connection ready and I want to run the following query to append the existing table in the database “fsv_test”. Can you please give some advice? I use exactly the same query in SQL Management Studio and successfully update the table but can’t make it work through UiPath database activity.
Insert Into test_connection1
Select * From Openrowset(‘Microsoft.ACE.OLEDB.12.0’,
‘Excel 12.0; Database=C:\Users\Test_1.xlsx’, [Sheet1$]);”
I read something about stored procedure but I am not sure if it is applicable to this case???