Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2009
    Location
    Philippines
    Posts
    7

    Post Unanswered: extract file from oracle into excel

    good day!

    Now I'm using oracle discoverer 10g and I want to extract may file into excel without splitting into multiple sheets. My files is about greater that 16000 and up and every time it reaches the 16000 rows it split to another sheet but I want it into one sheet only. What are the possible reason and how can I make it in one sheet only?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    That will be an Excel limit, not an Oracle issue. Newer versions of Excel allow more rows - see here.

  3. #3
    Join Date
    Apr 2009
    Location
    Philippines
    Posts
    7

    Exclamation extract file from oracle into excel

    i know the limit of excel 2003,,, but then it 65ooo plus to accommodate the more than 16000 rows... why does it happened that it split the into another spread sheet?

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    I don't know - this should be asked in an Excel forum, not an Oracle forum!

Posting Permissions

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