Excel database connection


#1

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.


How to use Excel as datasource and execute SQL Query?
#2

Hi @1290431,

Refer this post.
@acaciomelo

Regards,
Arivu


#3

Hi
I am using the same but still facing the issue. I am using Oledb.

Regards,
Ashish


#4

Hi
Please provide a solution.
Regards,
Ashish garg


#5

It is not working. can anyone please assist.


#6

is excel extension type is XLS/XLSX?


#7

CHeck if the SHeet name you’re using is correct