Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    1

    Unanswered: problem with Expoting to excel.

    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.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Moved to appropriate forum - you should get more joy here.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2004
    Posts
    62

    Try to use a raw file

    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.

  4. #4
    Join Date
    Jan 2005
    Posts
    362

    jcom

    jcom may help you.
    A tutorial

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •