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 |
|
saini_balvinder
Starting Member
22 Posts |
 Posted - 2008-01-22 : 23:02:37
|
| Hello,i am using sql server 2000. I have a DTS which generates data and exports it to msexcel template file. The file is then FTP to web server.how can i make sure that if records are more than 65535, it will copy rest of data to another sheet.i know we need to use page breaks for this but dont know how to implement it in sql server 2000.Any help will be appreciated. |
|
|
saini_balvinder
Starting Member
22 Posts |
Posted - 2008-01-23 : 01:19:06
|
| any replies for this guys? thx |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-01-23 : 22:25:39
|
use excel 2007 ?search for pagination in this site. There are various technique being discussed there.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
saini_balvinder
Starting Member
22 Posts |
Posted - 2008-01-23 : 23:38:18
|
| sorry, but what this has to do with exporting to excel? and how it will copy data to another sheet once first sheet is full?thx |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-01-24 : 00:05:38
|
excel 2007 can handle 1 mil rows
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-24 : 00:28:42
|
| are you using excel 97 or something? Try using a csv format file instead.are you ftping to the webserver to distribute the excel file, or are you using this a datasource for your website?-ec |
|
|
|
saini_balvinder
Starting Member
22 Posts |
Posted - 2008-01-24 : 01:10:21
|
| the file is generated in db server by dts and then ftp to webserver from where the users can download it. |
|
|
|
|
|
|
exporting data more than 65535 records