Posted: 16 Feb 2018 4:37 EST Last activity: 6 Nov 2018 20:02 EST
Unable to see microsoft.ACE.12.0 in Datalink properties using office 2016 or office 2013
Trying to create connection string for excel using OLEDBQuery, but could not able to see Microsoft.ACE.12.0 option in data link properties. but is available for office 2010, if anyone having idea please help on this.
Please find attachment jpg file for your reference.
The OLE DB Providers are not part of Pega Robotics. "An OLE DB provider is a software component enabling an OLE DB consumer to interact with a data source. OLE DB providers are analogous to ODBC drivers, JDBC drivers, and ADO.NET data providers." (source Wikipedia) In the list are what is installed on your machine. If you need another provider, you will need to install it.