How to insert datatable to a mysql database table

[Tamilarasanaccet (Tamil)]

I want to insert the datatable containing 4000 records that shoud be inserted to mysql database table at a single insert to reduce time i need single insert can anyone help me on this.

[AshwinS2 (Ashwin S)]

Hi @Tamilarasanaccet

Check this

Inserting a simple excel file into a mysql database

Hello i am new to UIpath and i am still learning , so part of my requirement i need to get the data from excel into a database lets say a mysql db table.I have created the required tables in the database and a small excel file with names, i want that to be inserted into my database. I have created the odbc dsn connection too as required and passed into the configuration .But while executing its always inserting Null values into the table.Am i doing anything wrong in passing the parameters value…

Thanks
Ashwin S

[Tamilarasanaccet (Tamil)]

@AshwinS2 I am getting error like this INSERT: ERROR [42S22] [MySQL][ODBC 5.1 Driver][mysqld-5.7.24-log]Unknown column ‘System.Data.DataRow’ in ‘field list’

[AshwinS2 (Ashwin S)]

Hi @Tamilarasanaccet

Mention the column name like row(“Column1”).ToString

Use Bulk Insert query like insert into table name(column1,column2) values(“+row(“Column1”).ToString+”+row(“Column2”).ToString+"')

Thanks
Ashwin S

[Tamilarasanaccet (Tamil)]

@AshwinS2 but i am passing datatable as the value there how can i mention row(“column”) can show me the sample

[amaresan (Amaran)]

@Tamilarasanaccet

DT1.Rows(0).Item(“ColumnName”).ToString

[Tamilarasanaccet (Tamil)]

@amaresan hi bro it insert first value only that is the datatable containing first value.

i need insert all the value of datatable at a single insert