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

1
Replies
121
Views
 Ralph Jordan (Ralph_Jordan) OpenSpan Inc
OpenSpan Inc
US
Ralph_Jordan Member since 2017 14 posts
OpenSpan Inc
Posted: April 22, 2020
Last activity: April 22, 2020
Posted: 22 Apr 2020 14:49 EDT
Last activity: 22 Apr 2020 15:38 EDT
Closed

What’s the best way to include Microsoft Access in an automation?

Report

I'm trying to get data out of an Access database, what's the best way to do this?

Pega Robotic Automation 19.1 Robotic Process Automation Robotics System Architect
Posted: 2 years ago
Posted: 22 Apr 2020 15:38 EDT
Rushabh Shah (Rushabh Shah) PEGA Software Engineer, Robotics Engine
Pegasystems Inc.
US
Report

Pega Robotics Automation doesn’t support direct integration with the Microsoft Access application. You may get some success using UI Automation methods and SendKeys using a windows adapter.

The preferred approach is to use the OOTB ODBC Query component. This component can be linked up to the MS Access database and can be queried upon for returning desired data.

You can find more information about the component here:

 http://help.openspan.com/191/components/Using_the_ODBC_Query_Component.htm

 

Ralph Jordan

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