Question

2
Replies
90
Views
JessicaV8159 Member since 2019 7 posts
NA
Posted: November 5, 2019
Last activity: November 6, 2019
Closed

Excel Import/ExportData Taking Too Long

I have an automation that runs reports from a web application, then exports the output to Excel. From there, I export it to a data table and then import that into a different excel macro-enabled workbook. I am currently using the Export/Import Data methods, and it works... it just takes a very long time. The reports can vary anywhere from 0-26k data entries and up to 30mins for each report to finish. Is there a quicker way to do this? Any help would be appreciated.

Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn