How to export sql server data into multiple csv sheets ?
-
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
-
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! -
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/ -
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
-
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.:-)
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/ -
Welsh Corgi (12/5/2011)
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.:-)
Do I read "a new addict" ?
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
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply