How to insert excel in MySql using uipath

[Raja.G (Mr.RPABot)]

Hi Guys,

I need to insert excel data to insert MySql database, please anyone help this.

Regards,
Raja G

[shanmukh_pothamsetty]

@Raja.G

Please check these links:

How to insert data into database table?

hey @aksh1yadav how to dump excel file into database using uipath Main.xaml (7.9 KB) i try this bt this gives me error

How to insert data in mysql?

Hi ronan, Sorry for the late reply. I try to give my database/ column/ Table names in the name column but it is still showing the same error message. And my Variable type is already in the string. i tried in many scenarios i really don’t know how to fix this

How to insert datatable to a mysql database table

@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

How to insert data into Database from using UiPath, getting error "Invalid Column Name"

Hi, yes I checked , the connection seems fine, i have used Connect command above my execute non-query, it does establish the connection as i have put one message box to see the same. the values comes in message box, and but after that it says “invalid column name” not sure why this happening. any other info required , let me know [image]

Regards
Shanmukh

[Raja.G (Mr.RPABot)]

@shanmukh_pothamsetty thanks i ill check

[Snehal14Kapse (Snehal)]

Hello @Raja.G Use Read Workbook Activity instead of using Read Range Activity. Extra columns/rows will be added if you don’t provide exact range in Excel Read Activity.

Store Result in Data-table & use Insert Activity to store data inside Database.