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 will be really grateful for any suggestions.