Question

2
Replies
90
Views
Close popover
Dipesh Barakoti (DipeshB2)
Coforge BPM
Associate System Architect
Coforge BPM
US
DipeshB2 Member since 2018 5 posts
Coforge BPM
Posted: February 4, 2019
Last activity: February 25, 2019
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

Robotic Process Automation
Moderation Team has archived post