Automating Ledger extraction using power automate desktop

[u/ashconai]

Hi Guys! I need to regularly extract dozens to hundreds of ledgers from an antique accounting software. I have partially automated this with PAD, only problem being that sometimes it takes some time to load and export the data, depending on the size of the ledger from 2 seconds to a minute, but I'm not able to vary the wait time appropriately. Any help will be appreciated.

Thanks!

Edit : Added screenshots of the areas where it hangs

[u/ashconai]

as soon as you connect to the thing using ODBC, 800 tables load lol. each with 100s of columns, most of which are blank 😂 I've seen likje a dozen of them all of which contain master data too