How to use Excel as datasource and execute SQL Query?

[kawalkarhemant (coder88)]

Hi Team,

I am trying to connect Excel as datasource, but not able to connect. I did some research and found following post.

Excel database connection

Hi Team, i am trying to use connect activity for excel database connection. But when I run my automation it throws an error saying " An error has occured Source: Newtonsoft.Json Message: Cannot create and populate list type System.Data.OleDb.OleDbErrorCollection. Path ‘$values’, line 1, position 164. I am using the below “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” & ExcelPath & “;Extended Properties=‘Excel 8.0 Xml;HDR=YES;IMEX=1’;” Provider name=“System.Data.OleDb” Please help me out…

But still it is not helpful getting same error as mentioned.
I have attached the excel file. I am looking for correct connection string for xlsx or xls and SQL query.
Source.xlsx (8.6 KB)
Kindly assist.

[kawalkarhemant (coder88)]

I did changes in Connection string as per below and it worked.

Connection String : =

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

SQL Query : - “select * from [Sheet1$]”