TOAD hangs while writing the excel file after exporting very large recordset to Excel (in xlsx extension and Excel 2007). Recordset has 1 million records.
To perform large recordset export, perform the following:
1. Right-click the data grid and select the "Export Dataset" option.
2. The Export Data windows appears, select "Excel Instance" under Export format. (Ensure that "Excel instance" is selected). The option to specify the output file will be disabled.
3. Change the options according to preference.
4. Click OK and export will begin. This will take a few minutes.
5. Once the export is completed, the Toad will output the total number of rows that have been exported. After export is completed, an Excel.exe will autostart to display the exported result which may take up more than 1 worksheet, as Excel has a limitation on the number of rows per sheet.
