How to use Excel as datasource and execute SQL Query in UIPath

Question

  I am trying to connect Excel as data source in UIPath. But getting some error. I did some research and found following post-UIPathForum

But still, it does not help getting the same error as mentioned. I am looking for correct connection string for xlsx or xls and Sample select SQL query.

My Excel file looks like below C:\Source.xlsx

Worksheet named - Sheet1

ID  |   F_Name  |   Score

1   |   Hemant  |   12

2   |   ABC     |   34

3   |   ERT     |   12

I have tried following Connection string and SQL Query

Connection String : - "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:\Source.xlsx";Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1';"

 

SQL Query : - "Select * from Sheet1"

 

Answer 1

 You can try this 

Connection String : =

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Source.xlsx;Extended Properties=Excel 12.0 Xml"

SQL Query : - "select * from [Sheet1$]"