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?

We don’t have any support for that. If you needed to use this in an automation script so you repeated the process I would suggest ordering the results and then doing separate queries for each set of 100.

In Oracle:

select * from table
where rownum > 0 and rownum
order by 1

your suggestion is brilliant but what is the way to do it in coding ;/

This thread seems to get continued in another thread. sample is at the end of this thread