SQL Server Performance

exporting 3 lakh of records to excel

Discussion in 'SQL Server DTS-Related Questions' started by rajeshy, Nov 15, 2004.

  1. rajeshy New Member

    Hi everyone,

    I am facing a problem regarding exporting of nearly 3 lakhs of data from sqlserver 2000 to ms-excel. I do it simply but it is showing errors that, excel can not store data more than 65,536.
    Is there any way that either I can mention to export remaining data to next worksheet in excel or export the whole data in single worksheet

    Please reply soon!

    Thanks in advance



    Regards
    Rajesh Yadav
  2. Argyle New Member

    I think you would have to do that via some scripting in DTS to only send 65000 rows to each worksheet.http://www.sqldts.com might be able to help.

Share This Page