exporting 3 lakh of records to excel | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

exporting 3 lakh of records to excel

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
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.