Home Forums SQL Server 2008 SQL Server 2008 - General Am not able to export 10 lakh records to excel sheet. RE: Am not able to export 10 lakh records to excel sheet.

  • January 10, 2013 at 11:08 pm

    #1576072

    ravi@sql (1/10/2013)

    Hi thank you all for the support.

    Finally i exported data using SSIS and it works fine .

    Regards,

    Ravindranath.s

    can u please explain how ?

    because for excel 2007 ,row limit is 10,00,000 and you mentioned that there are 11,00,000 + records in table.

    -----------------------------------------------------------------------------
    संकेत कोकणे