Need Help - Run Query Command

Help Activities
, , , ,
1

Description

Hi There ,
I am trying to read an excel(.xls file) which has 6 lakh records. Hence i created a connection string using Connect to DB Activity.
Next when i am using Run Query Activity to write select query to fetch the complete the data from the excel. However i am unable to get the table that should suppose to mention in the select query.
Select * from (What table i need to refer here ) ?
Kindly suggest.

Link

https://cloud.uipath.com

Date

2024-12-05

Related UiPath products

Studio

2

Hi @avinashy

As you are reading from excel. Your table name would be name of the sheet

SELECT * FROM [Sheet1$]

Hope this helps :slight_smile: