Solution ready for exporting data into excel file into MULTIPLE sheets for more than 65535 rows

Question

Post reply

Solution ready for exporting data into excel file into MULTIPLE sheets for more than 65535 rows

PaVeRa22

SSCommitted

Points: 1965
More actions
July 14, 2010 at 12:19 pm

#141038

Hi Guys,
I have solution for exporting data into excel file with multiple sheets for rows more than 65535, i wanted to publish it, I sent email to articles@SSC email address 10 days ago, didn't received any reply.
Could some one help me, to whom should I send this article for publishing in SSC?
Regards

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

I have an easy solution for that problem:

use Excel 2007 or later 😉

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Phil Parkin SSC Guru Points: 246962 More actions · Answer 2

da-zero (7/15/2010)
I have an easy solution for that problem:
use Excel 2007 or later 😉

Same as my solution!

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

Phil Parkin (7/15/2010)
da-zero (7/15/2010)
I have an easy solution for that problem:
use Excel 2007 or later 😉
Same as my solution!

:blink: You stole my idea! 😛

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

PaVeRa22 SSCommitted Points: 1965 More actions · Answer 4

da-zero (7/15/2010)
Phil Parkin (7/15/2010)
da-zero (7/15/2010)
I have an easy solution for that problem:
use Excel 2007 or later 😉
Same as my solution!
:blink: You stole my idea! 😛

Hi Da-Zero / Phil Parkin,

Thanks for your replies, actually you didn't answered to my question.

I know the easy solution is Excel 2007, most of the people are using 2003 and earlier versions, it might be helpful to them.

My solutions working even in excel 2007 i.e for rows > 1048576 ( 16 * 65536)

Actually I developed this solution for excel 2007, converted to work with earlier versions too.

Cheers

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

I know we didn't answer your question. 🙂

But I would be interested in reading such an article.

Maybe you can try to send a reminder, or to contact the editor of this site.

Or just have some patience, I can imagine that SSC receives tons of e-mail.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

PaVeRa22 SSCommitted Points: 1965 More actions · Answer 6

daz...,

Thanks, now you answered my qtn :-);-)

I will send one more email...cheers

maheshv 14393 Grasshopper Points: 18 More actions · Answer 7

Could you please post the code to my mail id maheshv@nextedgesoftware.com

guru12 Ten Centuries Points: 1068 More actions · Answer 8

Hi, can you please send the solution for my e-mail:

narasimha.pothineni@syncoms.com

Regards..

Anil...

Regards..
guru12

Thanh Ho SSC Rookie Points: 29 More actions · Answer 9

Hi PaVera22,

Could you send this Solution to us as well at thanhnghia@hotmail.com , we are quite interested in this for our project at the moment.

Regards

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 10

PaVeRa22 (7/14/2010)
Hi Guys,
I have solution for exporting data into excel file with multiple sheets for rows more than 65535, i wanted to publish it, I sent email to articles@SSC email address 10 days ago, didn't received any reply.
Could some one help me, to whom should I send this article for publishing in SSC?
Regards

Email: articles@sqlservercentral.com

and ask if they received the email you sent earlier.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]