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.