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 |
|
gcowhsu
Starting Member
38 Posts |
 Posted - 2005-08-10 : 12:12:31
|
| I have a problem that one of my reports returns over 1500 pages of data and that converts to 70000+ rows in Excel. Since Excel can not handle that many rows the export fails. My co-worker said it is possible to export data to multiple sheets in a workbook. Does anyone know how to do this?thanksMichael Hsu |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-08-19 : 10:04:44
|
| I would like to know this also. |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-08-30 : 11:20:02
|
| I think one of the guys that developed the Reporting Services said it would be an update on one of the coming SPs, I think it was on one of the web casts that microsoft has...Igor. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-08-30 : 11:53:45
|
| you could (in the interm) run 2 queries...1 to produce a report listing the 1st 50000 rows, and a 2nd to list from 50001+pseudo-paging per-se. |
|
|
|
|
|
|
Excel Export to multiple sheets