problem with Expoting to excel.

amruta13 · #1 (**permalink**) 10-31-06, 23:55

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.

pootle flump · #2 (**permalink**) 11-02-06, 06:09

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

pakcik_kantin · #3 (**permalink**) 11-10-06, 08:10

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.

dimis2500 · #4 (**permalink**) 11-14-06, 10:29

jcom may help you.
A tutorial

Internet Services

Web Development

Digital Marketing

Consumer Tech