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

 Dipesh Barakoti (DipeshB)
Coforge BPM
Associate System Architect
Coforge BPM
US
DipeshB Member since 2018 6 posts
Coforge BPM
Posted: Feb 4, 2019
Last activity: Feb 25, 2019
Posted: 4 Feb 2019 10:29 EST
Last activity: 25 Feb 2019 11:42 EST
Closed

Excel taking long time to import table from ODBC query.

Hello,

I have ODBC query that filters .mdb file and import a table to excel. The database connection doesn't have a problem and query is also executing fine but when it comes to excel, it takes almost 30 mins to import 3000 rows. The excel connector itself doesn't respond until all import is done and freezes. We also checked if there is a resource conflict by setting it to asynch but it didn't improve the speed. Does anybody knows how we can increase the excel import speed?

I am using Robotics Studio 8.0.2014.0

Excel connector 2016

ODBC query component from toolbox

Microsoft OLE DB Provider for ODBC Drivers

Also attached is a screen shot of my automation.

Thanks

To see attachments, please log in.
Robotic Process Automation

  • Anil Nuthalapati

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