Excel data to sql data base

Can i know how to export excel data to sql database

First you need to set up connection using the database connection activity.
Then you can directly pass the excel values to data table and to the database tables.

@Mahesha_Mendis - you can red the excel into data table and then use connect database activity to connect to your SQL server… After that use you can update the database.

Let me know if you face issues

Thank you all of you i can connect to database and insert data

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.