Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sarveswara Reddy (Sarveswara Reddy) Eclatprime Digital Pvt. Ltd Senior tech lead
Eclatprime Digital Pvt. Ltd
AU
Sarveswara Reddy Member since 2017 12 posts
Eclatprime Digital Pvt. Ltd
Posted: Feb 16, 2018
Last activity: Nov 6, 2018
Posted: 16 Feb 2018 4:37 EST
Last activity: 6 Nov 2018 20:02 EST
Closed
Solved

Unable to see microsoft.ACE.12.0 in Datalink properties using office 2016 or office 2013

Hi,

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.

Thanks in advance

To see attachments, please log in.
Robotic Process Automation

Accepted Solution

Posted: 6 years ago
Posted: 8 Apr 2018 8:02 EDT
Sarveswara Reddy (Sarveswara Reddy) Eclatprime Digital Pvt. Ltd Senior tech lead
Eclatprime Digital Pvt. Ltd
AU

Thank you so much Jeffbadger....

i am happy with your answer, my issue got resolved after installed "AccessDatabaseEngine" for 2013 & 2016..

 

To see attachments, please log in.
Posted: 6 years ago
Posted: 7 Mar 2018 11:35 EST
Sarveswara Reddy (Sarveswara Reddy) Eclatprime Digital Pvt. Ltd Senior tech lead
Eclatprime Digital Pvt. Ltd
AU

Thank Grona, 

i understood, this functionality got missed out for MS office 2013 or latest. DLLs are not supporting from latest Office. please help on this.

this is support for who are all working for OLEDB connection and instances create(Excel 2013 or 2016). 

To see attachments, please log in.
Posted: 6 years ago
Posted: 7 Mar 2018 16:00 EST
Jeff Badger (jeffbadger) PEGA Principal Product Manager, Robotics
Pegasystems Inc.
US

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.

Show More

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.


Show Less
To see attachments, please log in.

Accepted Solution

Posted: 6 years ago
Posted: 8 Apr 2018 8:02 EDT
Sarveswara Reddy (Sarveswara Reddy) Eclatprime Digital Pvt. Ltd Senior tech lead
Eclatprime Digital Pvt. Ltd
AU

Thank you so much Jeffbadger....

i am happy with your answer, my issue got resolved after installed "AccessDatabaseEngine" for 2013 & 2016..

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice