Excel database connection

Help
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.

Error
Error994×280 43 KB

2

Hi @1290431,

Refer this post.
@acaciomelo

Regards,
Arivu

1 Like
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

8

Hi @1290431,

Please refer to this post.

I posted a xaml for helping achieving this.

Regards,

Bruno Costa.

9

Guys,Here is a detailed article on that :slight_smile: