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

 Ralph Jordan (Ralph_Jordan)
OpenSpan Inc

OpenSpan Inc
US
Ralph_Jordan Member since 2017 14 posts
OpenSpan Inc
Posted: Apr 22, 2020
Last activity: Apr 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?

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

To see attachments, please log in.
Pega Robotic Automation 19.1
Robotic Process Automation
Robotics System Architect

Posted: 5 years ago
Posted: 22 Apr 2020 15:38 EDT
Rushabh Shah (Rushabh Shah)
PEGA
Senior Software Engineer, Robotics Engine
Pegasystems Inc.
US

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

 

To see attachments, please log in.

Related content:

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