Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    41

    Unanswered: Excel > 65000 rows

    Hi

    We are trying to export some data from SQL server
    into an excel sheet. No of records will be like
    more than 1 lakh records. I noted that Excel has
    a constraint of not creating rows more than 65,000.
    In this case we need to create multiple workbooks
    in the excel sheet.

    Thanks

  2. #2
    Join Date
    Oct 2003
    Posts
    17
    Hi,

    Majority on the group may not know that 1 lakh means 100,000
    You can check the specifications in the help under very first topic : Getting Started / Microsoft Excel specifications.

    HTH,

    Jp

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    65,536 to be specific. Give or take a lakh
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  4. #4
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    or just being pedantic 2^16

Posting Permissions

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