Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reachgopal
Starting Member
1 Post |
 Posted - 2004-12-20 : 11:31:46
|
| Hello:We are trying to export some data from SQL serverinto an excel sheet. The data records will be likemore than 1 lakh records. I noted that Excel hasa constraint of not creating rows more than 65,000.In this case we need to create multiple workbooksin the excel sheet.Could you please help me how to creat multipleworkbooks thru DTS in run time - if it is >65,000?Thanks for your help,Regards,Gopal R |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-12-23 : 10:42:48
|
| One way might be to split your data into chunks of 65,000 records e.g. SELECT TOP 65000 ....steveTo alcohol ! The cause of - and solution to - all of life's problems |
 |
|
|
|
|
|
Excel export constraint