Question

2
Replies
85
Views
DipeshB2 Member since 2018 5 posts
Ruletek LLC
Posted: 1 year ago
Last activity: 1 year 6 months ago
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
Share this page LinkedIn