Connected to SQL Server 2012 on Toad Data Point 3.3 to perform an export template using a Stored Procedure to generate a dataset and save it to an Excel (.xlsx) file. The results is almost 22,000 rows; however the resulting Excel file only writes 1,465 records.
Viewing the event log it's writing the data in blocks of 5,000:
But it seems to overwrite each sequence before and only write down to the Excel file the last block which equates to 1465 rows.
WORKAROUND:
In the Export Wizard, increased the read buffer size to 40K read\write all rows in one block.
