How to enter multiple sheets in sql

how to enter multiple sheets of excel in different folder in sql through uipath

Hi @guptasweb

Are you trying to insert rows into the same table but read from different spreadsheets?
Or do these sheets contain different data meant for different database tables?

In either case, you can pass a DataTable object through the Insert activity
You may also use Bulk Insert to do that

i have 4 files in each excel file there are two sheets i have to create a data in sql through uipath and write the status whether its done or not pls help me

Here is a solution that can help you achieve this:

Also, in future it will save you the time to make a new post if you use this search feature at the right-top of the forums page:

Happy automation!

this doesn’t work

Can you please give specifics into what exactly doesn’t work?

Providing more details about the issue (preferably including screenshots) will ensure you get help quicker.

:point_right:t3: Forum FAQ - Beginner’s guide :point_left:t3: