error|690x388 I cannot insert the datatable into database with Insert activity. I checked the parameters they are same as the table in database also names of header in datatable are same as that of database. I also used execute non query in the for loop for getting the data per row but that didn…

Hi @Hemil_Shah Please find the below example insert query for your reference. “insert into Your Table Name (Column1,Column2,Column3,Column4,Column5,Column6,Column7,Column8,Column9) values ('”+row(“Column1 Name”).ToString+“‘,’”+row(“Column2 Name”).ToString+“‘,’”+row(“Column3 Name”).ToString+“‘,’”+…

Insert data from data from datatable to database

Help Activities

vignesh.ks (Vignesh Ks) March 26, 2021, 10:33am 2

https://forum.uipath.com/t/how-to-insert-excel-data-into-my-sql-workbench-database/292225/3?u=vignesh.ks

Hi @Hemil_Shah

Welcome to UiPath Forum.

Please find the attached link. Try that method.

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

Topic		Replies	Views
How to insert a datatable into SQL Server database using Uipath database activities? Activities database	5	9331	November 18, 2021
Can't insert Data into a database table from an excel sheet Help	15	1630	September 1, 2019
Datatable from excel to ms-sql data table Activities datatable , excel , database , uiautomation , robot , activities , studio , question , ms-sql	2	706	April 18, 2023
Insert Datatable into SQL database based on column names Help studio	2	3537	July 4, 2019
Database query issue Help database , activities , question	4	862	November 26, 2019

Most Active Users - Yesterday
sharazkm32
singh_sumit
ashokkarale
lrtetala
prashant1603765
sonaliaggarwal47
Justin_Tan_Jun_Song_EE
Anil_G
mively
shrikrushna.bhoi
More details...

Insert data from data from datatable to database

Related topics