How to feed a data from excel to database

datatable
excel
database
activities
studio

#1

Hi all,
As I’m new to Uipath need a help reg exporting an excel data to my database (Mysql) using Execute non-query activities if having an example please help me reg the same.


#2

@info2sri94 i have created the basic structure for inserting data from excel into database. Please find the file below.

database.xaml (12.9 KB)


#3

Hi
I’m facing the below issue
{
“message”: “myodbc3.dll : ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-5.6.14]Column ‘mobile_name’ cannot be null”,


#4

@info2sri94,Allow nulls in mysql table for the column name mobile_name