How to enter multiple sheets in sql

Help Studio
, ,
1

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

2

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

3

yes.how to do that

4

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

5

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:
image

Happy automation!

6

this doesn’t work

7

@guptasweb
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: