I want to download data from Excel Using ADODB, but I’m struggling with connection. I’m using Execute Query with following parameters:
ConnectionString - “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=” + ArchivePath + "; Extended Properties=Excel 12.0 Xml;HDR=YES; "
SQL - “select * from [OldCases]”
The problem is that I receive Validation error - “None of the overload groups have all their required/optional activity arguments configured.”
When I add Provider Name - “Microsoft.ACE.OLEDB.12.0” validation error disappears, but now I get
I think main question is what should be typed into ProviderName field, Microsoft Ace is not available in UiPath dropdown.
I tried to do this in Invoke Code Activity, but I get deserialize JSON error.
Result = New DataTable()
Dim conn As New OleDb.OleDbConnection
Dim comm As New OleDb.OleDbCommand
Dim da As New OleDb.OleDbDataAdapter
conn.ConnectionString = “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=” + Path + “; Extended Properties=Excel 12.0 Xml;HDR=YES;”
comm.CommandText = “select * from [OldCases]”
comm.Connection = conn
da.SelectCommand = comm
da.Fill(Result)