Using the package UiPath.Database.Activities, I am connecting to a database with an account that is only able to insert data, but does not have SELECT permission. I am using the ‘DatabaseConnect’ activitie to configure the connection. After that, im using the InsertDataTable to insert a datatable …

Database activities - Insert datatable

ppr (Peter Preuss) August 23, 2023, 2:02pm 12

We do feel that easy the Datatable can be transformed into the SQL Code lines, when this is preferred.

Topic		Replies	Views
Insert Activity with SQL Help	1	876	March 16, 2020
Insert data from data from datatable to database Activities uiautomation , activities , question	7	3464	March 30, 2021
How to insert a datatable into SQL Server database using Uipath database activities? Activities database	5	8560	November 18, 2021
Error encounter while using 'Insert' activity within database package Help excel , database , activities , error , question	1	1227	November 20, 2019
Unable to use the Insert activity to append data from a datatable into an Access Database Help	9	1910	April 15, 2021