Data Base query to excel File

Help Studio
, ,
1

I want to run the query in the database and show to the output of the query in the Excel file my connection has been established and I am able to insert the values in the database but when i am doing Select * from table name its not showing any data and not giving any output
so how can i insert the data in the excel file

2

Hi @Jay_Chaudhary ,

Give Timeout for run query. If you have to select huge data. increase your timeout .

Screenshot 2023-05-08 111803
Screenshot 2023-05-08 1118031373Ă—227 22 KB

Thanks!

3

image
image1920Ă—1080 248 KB

Still not working

4

try adding “;” after the table name and check

Regards

5

Hi @Jay_Chaudhary ,

Can you try once manually in query editor. if you get table or not.

Can you try to write a excel file for datatable.

Thanks!

6

I have tried this using write excel file in flow chart but nothing output

7

Hi @Jay_Chaudhary ,

Can you try once manually in query editor. and pls share the screenshot for that.

Thanks!

8

I am not able to understand what u want me to do

9

Pls run your SELECT query manually in DB. and check you can get output or not.

10

Yes i am getting answer manually but not geting the output in the UiPath

11

@Jay_Chaudhary

Check below syntax

image
image784Ă—94 1.32 KB

“SELECT * FROM rpauipath;”

Hope this may help you

Thanks,
Srini

12

Hi @Jay_Chaudhary
Could u please do a break point after the run querry executes. And show the datatable value in watch panel.so that we can check…
Hope u have completed the basic of DB connections

Thanks
VP

13

Hi @Jay_Chaudhary

I hope you are doing this way-

  1. Use the connect activity in UiPath to establish a connection to the database. You will need to provide the necessary connection string, username, and password.
  2. Use the Execute Query activity to run your SELECT statement and retrieve the data from the database. The activity will return a DataTable object that contains the results of your query.
  3. Use the Write Range activity to write the data from the DataTable to an Excel file. Specify the range where you want to write the data, as well as the path to the Excel file.

Thanks!!

14

@Nitya1 @Srini84
the activities execute a query is not available now

image
image1920Ă—1080 286 KB

in latest updates so what can i use now and the @Srini84 check SQL command its still not giving any output

15

Hi @Jay_Chaudhary

Firstly can you check if the database connection established sucessfully.

Thanks!!

16

Yes mam database connection has been established and when i am inserting the data the data is inserted but not able to fetch the data

17

@Vishnuraj_Pandiyarajan2

image
image1920Ă—1080 174 KB

sir check whats the eroor

18

@Jay_Chaudhary

You can’t directly get the data from a datatable like that

You need to have another activity as output Datatable activity, This will convert the Datatable to a String

Then that string you can pass to Messagebox to view the content

Hope this may help you

Thanks,
Srini

19

thanks for the solution
it worked

1 Like
20

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