How to export sql server data into multiple csv sheets ?

Question

How to export sql server data into multiple csv sheets ?

steven_nguyenhuy

SSC Veteran

Points: 221
More actions
December 5, 2011 at 11:10 am

#100428

Hi,
I'd like to export 2 tables into multiple csv sheets (eg: sheet1 and sheet2). I don't want to do this from DTS or SSIS.
Any idea please email me ASAP.
Thanks,
Steve
Ps: SQL Server 2005/2008

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

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

well, what you are asking is how to create an Excel document with multiple sheets; '

a CSV is actually a raw text file, which by default opens in Excel, which converts it to excel format, and then of course multipel sheets are available.

so a plain old CSV does not have multiple sheets.

by eliminating SSIS from the mix, you are kind of limited to using either a linked server or openrowset, i think.

In that case, the sheets must already exist, and you can then update them, i believe...is that a possiblity for you? can you use a default document ?

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!

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Would you consider SSRS?

http://weblogs.sqlteam.com/joew/archive/2008/11/12/60755.aspx

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Johan Bijnens SSC Guru Points: 135368 More actions · Answer 3

Does Powershell come in to picture ?

http://ask.sqlservercentral.com/questions/36601/powershell-export-multiple-tables-to-csv

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

ALZDBA (12/5/2011)
Does Powershell come in to picture ?
http://ask.sqlservercentral.com/questions/36601/powershell-export-multiple-tables-to-csv

A lot less effort.:-)