You’re offline. This is a read only version of the page.
28
I should export a SQL db to excel online with many lines (like 32.000).
Is there a way to bypassing "row-by-row" process? Maybe by copying the entire sql database or better, create an incremental excel database?
It's not possible to create mutiple row in Excel with Flow but if there is an ID or something like this in your SQL rows, you can use it with a counter and a recurrent trigger to start multiple execution of your program.
And for each execution get 1 or more rows from SQL and add it into Excel.
But for Excel you can only do 100 calls every 60 sec so add in the parameter of SQL and Excel a Timeout and a Retry strategy to avoid error.
And no matter what, for 32 000 lines, it will take around 5 hours to do it.
Share
Report
All responses (
Answers (
