When copying to Excel there is an upper limit of 65k records (at least in my version).
Could you make extra worksheets when there are more records then Excel can handle?
I see 2 solutions:
- start a new sheet after 65000 records (set it in the preferences) so I have some room to handle the records.
- Even better is when you could start a new sheet when one of the columns of an "order by"-clause change value.
Thank you,
Roeland