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 |
|
GhantaBro
Posting Yak Master
215 Posts |
 Posted - 2010-07-13 : 12:11:38
|
| Guys needed to check what is the best way to export data in 3 different sheets from different tables in one excel workbook? Thanks for the help. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-07-13 : 13:26:49
|
| One way - if you use the Export wizard - there is an option to choose the destination of any table to any worksheetJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
GhantaBro
Posting Yak Master
215 Posts |
Posted - 2010-07-13 : 13:34:20
|
quote:
Originally posted by jackv
One way - if you use the Export wizard - there is an option to choose the destination of any table to any worksheetJack Vamvas--------------------http://www.sqlserver-dba.com
Thanks Jack for the response... I have to do it for many files and cannot do it manually for each file using wizard.. I was planning to create Stored Proc or SSIS Package and pass filename and table name as parameters. My SQL server is 64 bit so can't use Openrowset. |
|
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-13 : 16:37:27
|
| i suggest you to use SSIS. it is relatively straightforward to do it in SSIS. |
|
|
|
GhantaBro
Posting Yak Master
215 Posts |
Posted - 2010-07-14 : 10:43:22
|
quote:
Originally posted by slimt_slimt
i suggest you to use SSIS. it is relatively straightforward to do it in SSIS.
Yes you are correct. I will do that. Thanks! |
|
|
|
|
|
|
Export 3 tables to 3 different sheets in Excel