Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLvoodoo
Starting Member
4 Posts |
 Posted - 2007-03-30 : 09:15:13
|
| Hi guys,Is there a way to export SQL Server data to Excel, but into multiple worksheets in the same workbook, instead of one simple worksheet?Thanks |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-03-30 : 13:18:51
|
| Directly from SQL I dont think so. But you could do it from an application lie VB.NET/C#..etc. May be the new version of IS has some features ..I havent worked on it yet.************************Life is short. Enjoy it.************************ |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
SQLvoodoo
Starting Member
4 Posts |
Posted - 2007-03-30 : 17:03:33
|
| Thanks guys for the replies, I'll look into that book for sure |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-04-02 : 08:40:57
|
| If you're using DTS (as I assume you are given where this is posted!), you can use multiple dataflow tasks to multiple Excel connections (one per sheet). The JET provider treats worksheets essesntially as tables.Mark |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Exporting SQL data to Excel (multiple worksheets)