How we push .xls file data into Database

Help
, , ,
1

Hello all,

im trying to take a input of excel file data which has file is .xls file.

and push that data in DataBase.

1 Like
2

@swanand_deshmukh

You can read the excel using read range and using Execute query you can insert the data into the database. You need to include UiPath.Database.activities packages.

For more help, share what kind of data and whats your datatbase (SQL or Oracle,…)

3

Fine
hope these steps would help you resolve this
–use excel application scope and pass the file path as input
–inside the scope use READ RANGE activity and get the output with a variable of type datatable named dt
–now go to manage packages option in design tab and in official tab search for UiPath.database.activities and install it
–once after installing then in activity panel search for INSERT activity where we can mention the variable dt as input datatable and in the table name mention the table name in your database
–before that we need to configure the connecttion with your database
kindly have a view on this thread for that to get more details

Cheers @swanand_deshmukh

1 Like
4

thanks to all this is very helpful to me

1 Like
5

Cheers @swanand_deshmukh

6

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