Hi,
I have a DB with 1.4million records and run 4 queries via sql to get the data i need. i then export to excel and combine into 1 workbook.
My issue is it is taking over an hour to export. ( all that is above is done by one button on a form)
The query only generates about 2000 rows and 800 columns of data in the excel file. And it is all text so no formulas or the like.
I have primary keys and a new laptop with 8mb ram and i5 processor (not super powerful but should handle a simple DB)
Are there any tricks/tips/formatting suggestions to speed up this excel export?