Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 4 of 4

Thread: SQL to Excel with more than 65536 rows

  1. #1
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default SQL to Excel with more than 65536 rows

    Hi

    Doing a standard SQL export to excel from SQL Management. the Customer.dbo has approx 90,000 rows. Tried to export in both Excel 2003 and 2007 but always hits the dreaded 65536 max rows error.

    Anyone got a way around this?

  2. #2
    DotNetDevelopments is offline Senior Member
    Join Date
    Jul 2008
    Location
    Harlow / Essex / UK
    Posts
    619

    Default

    Unless you are going call 60,000 rows at a time and paste them into excel, you could use two sheets in one workbook to keep them together or maybe even just a workbook each (two files at the end of it.)

    Alternatively you would have to get office 2010 which has extended limits.

    http://office.microsoft.com/en-us/ex...in=HP005199291

    Excel 2010 can handle up to 1,048,576 rows by 16,384 columns.

    However it sounds like this number is only going to keep getting bigger. I suggest breaking up your SQL statements. Depending on what data you need would CSV file be enough?
    =====
    Version (Code/DB): AspDotNetStorefront MSx 9.1.0.1/9.1.0.0
    Execution Mode: 64 Bit
    Dot Net Developments - E-commerce By Experience

  3. #3
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default

    Any idea if this will work with Excel 2011 (Mac)? Happy to download a copy to a boot camped Windows 7 but just want to keep this simple.

  4. #4
    DotNetDevelopments is offline Senior Member
    Join Date
    Jul 2008
    Location
    Harlow / Essex / UK
    Posts
    619

    Default

    You are in luck!

    http://www.nadynerichmond.com/blog/2...-2011-support/

    Mac's match Windows spec in regards to Office.

    Hope that helps!
    =====
    Version (Code/DB): AspDotNetStorefront MSx 9.1.0.1/9.1.0.0
    Execution Mode: 64 Bit
    Dot Net Developments - E-commerce By Experience