Hi all,
I need to export the results of query to excel file, but my query returns
more than 65000 records. I know only how to put it into the first sheet of excel file. Does
anybody knows how to force my data to go to the next sheet after exceeding
65000? I am doing this through Java and jsp code.
Amruta.

Moved to appropriate forum - you should get more joy here.

Try to use a raw format with pipe. Then consider open the file using excel.
If you want to do more, make excel to get datasources direct to your database.

jcom (http://sourceforge.net/projects/jcom/) may help you.
A tutorial (http://www.dev-archive.com/Java/Article/27463/0/page/1)