Excel data to sql data base

Help
1

Can i know how to export excel data to sql database

2

Hi,
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.

3

@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

4

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

5

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