Post reply

To Get the Resultset in Excel Format

  • January 4, 2010 at 10:17 pm

    #215190

    Hi To All;

    I will Run the QueryApproximately 700000 Records ;

    For example

    Select * From Studentmaster

    To Get the 700000 Records output;

    This Results are Directly To Connect The Excel Sheet and Convert the 65000 in to 7 Sheet's

    How is It Possible or Not;

    Thanks;

    A.Faijurrahman

  • January 5, 2010 at 6:33 am

    #1098894

    You have a few options including SSIS and also OPENROWSET in TSQL.

    Checkout this URL for some further info:

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

    Edit: An after thought, You will have to be on the 2007 version of Excel though I think the row limit is much less on older versions 64000 i think.

    Gethyn Elliswww.gethynellis.com

  • January 5, 2010 at 8:00 am

    #1098974

    Hi

    This is correct. Any version of Excel prior to 2007 could only hold 65536 rows per spreadsheet.

    In Excel 2007 the limit is now in excess of 1.2 million rows.

    Normally when doing a load of this size, one might also want to think of utilizing checkpoint commits, expecially if the row size is large. I have been caught by this before and Murphys Law states that this is normally during month end when all resources are required by end users.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply