How to add excel data to mysql

Help
5

Hi @DivyaT,

You can complete this using below steps

  1. Read Excel and store in Data table
  2. Build another data table with same column names and data types of database tables and merge both datatables
    or
    change the column name and datatype as per the column names and data types in database table.
  3. Use Execute non-query activity to insert the datatable into database.

Thanks,
Adhee

Happy learning!!

1 Like