Extract data from Excel and save to MySQL database

Help Activities
, ,
1

Hello everybody! I’m new with UiPath. I need to extract data from an excel spreadsheet, and save it in the database (MYSQL). However, it cannot be line by line, because my excel spreadsheet has 20 thousand lines. Thank you all :slight_smile:

2

@joyce_rufino

Plese follow the approach.

  1. Create a formula in excel…to form the insert rows for each rows…in a single column…
  2. Then use auto fill range to fill the formula in whole of the column…
  3. Read the data into datatable and string.join(“,”,dt.AsEnumerable.select(function(x) x(“ColumnName”).Tostring))

Now one statement of insert will add all the values together

Eg of multiple insert

INSERT INTO employee_details VALUES
(‘E40004’,‘SANTHOSH’,‘E102’,25),
(‘E40005’,‘THAMAN’,‘E103’,26),
(‘E40006’,‘HARSH’,‘E101’,25),
(‘E40007’,‘SAMHITH’,‘E102’,26);

In excel use concat to get the required for for each row

Cheers

3

Hi,

You can read the excel into a datatable and use bulk insert activity to insert the rows into the DB.
only condition is that the columns should be matching.

Please check the below documentations .