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 |
|
tzachari
Starting Member
1 Post |
 Posted - 2006-11-21 : 13:27:26
|
| Hi - I have a table that contains a list of members from different states as follows:id State Lastname firstname address 1 MA david john address 2 NJ donald tim addressetc, etc ....I need to export to data out into multiple Excel Workbooks for each State and I need to dynamically rename the workbook by the state code. How do I do this in DTS. I have googled this on the web and haven't found a single source of info. Any help appreciated. Thanks Very Much Zack |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-11-23 : 06:45:21
|
| Are you going to be creating new workbooks each time you run this, or will you be appending data to existing workbooks?Mark |
 |
|
|
|
|
|
Need Help in Exporting Data to multiple Excel Fil