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: 4 years ago
Posted: 22 Apr 2020 15:38 EDT
Rushabh Shah (Rushabh Shah)
PEGA
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:

Question

Is there a fast way to untangle an automation?

Question Solved

[Robotics] Is there a way to automate failover?

Question

What is the easiest way to retrieve an array of all Adapter objects in a Pega Robotic Automation Studio solution?

Question

what is the use of agile desktop automation?

Question

Pega Robotics unable to interrogate Desktop Microsoft Access

Question

How to access the files included in the project inside the code

Question

My RPA Service log file is missing information, what would cause that?

Question

Pega Robotics Automation and Microsoft .NET Framework 4.5 Multi-Targeting Pack

Question

Is it possible to add some provision to debug again which we have already completed debugging without closing automation?

Support Doc

Microsoft Edge update 113 prevents you from automating Edge with Pega RPA

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