silly customer requirement: export of 1mio+ rows to Excel

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
Hi!
Setup: call to proc in SQL Server 2005 (2008)
returns big resultsets.
Excel 2007 is not allowed to be used.
Resultset should be distributed amoung multiple sheets ( because of <font size=2>65535 limit).

(and resulting file should be zipped)

Has anyone made some generic code in C# that
can make this type of export?

Best regards
Bjorn D. Jensen

P.S. Tried to explain that this is not useful - without luck...

</font><hr class="sig B. D. Jensen

View the full article
 


Write your reply...
Back
Top