Export One Table Data to single excel file with multiple excel worksheets

Question

Export One Table Data to single excel file with multiple excel worksheets

Janaa

Say Hey Kid

Points: 707
More actions
February 15, 2011 at 3:52 am

#148466

Hi All,
I've nearly 8 lakhs records available in a table, I need to transfer it to .csv file, when i do it using Data Flow Task --> Old DB Source - Flat File Destination, and open the .csv file from C:\Temp it throws error msg as File not uploaded properly and returns only 65536 records.
Now am in need of once sheet 1 is loaded then the remaining datas will be loaded to sheet2, sheet3, sheet4, etc,....
Pls help me to resolve this issue.:crying::sick:

Viewing 5 posts - 1 through 4 (of 4 total)

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

Phil Parkin SSC Guru Points: 246695 More actions · Answer 1

If someone gave me a spreadsheet containing hundreds of thousands of rows on multiple sheets, it would be effectively useless to me. What is the requirement? Get users to open the CSV using another program. Or give them a summary of the data (=fewer rows). Or use Excel 2007.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Janaa Say Hey Kid Points: 707 More actions · Answer 2

My requirement is like that, if that is effectively useless for you means not for all. Possible help me, else leave it.

Anyone else give me an idea to get datas in multiple datasheets.

Phil Parkin SSC Guru Points: 246695 More actions · Answer 3

umajanaa85 (2/15/2011)
My requirement is like that, if that is effectively useless for you means not for all. Possible help me, else leave it.
Anyone else give me an idea to get datas in multiple datasheets.

You will find that people on this forum will often ask you for the reasons behind what you are trying to do. They do this because there are often better or more efficient ways of going about things than the original poster has even thought about. I did give you other options, but you appear not to have considered them at all and instead rather rudely told me to shove off. Not the best way to get help on a forum where people give up their time for free.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Lowell SSC Guru Points: 323504 More actions · Answer 4

Phil posted exactly what i would have...i would immediately question why your end users are using a tool to view data that is limited to 65536 rows of data;

The advantage of the forum is for you to learn from other peoples experiences (and mistakes)

you can export all the rows to the same old spreadsheet or csv file as before, and if the end users use the wrong tool to open the document, they get the expected, truncated view of the results. Like Phil said, if they open it in a different tool, whether EditPlus or Excel 2007+ or OpenOffice, that issue goes away.

I don't think that's the responsibility of the exported data to predict, and work around, a limitation that exists in the Chair-To-Keyboard-Interface

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!