Toad World® Forums

Export to multiple excel files



I have a table with 1 000 000 rows and want to export all records into excel. The excel file must have less than 9999 rows. So I want to split this into 100 files. Is there a way of achieving this automatically via Toad? If so, how?