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 |
|
william_lee78
Yak Posting Veteran
53 Posts |
 Posted - 2004-09-28 : 22:22:44
|
| Hi All,I know that DTS package can export data to excel. My problem is on how to position my column. I want to retrieve the early date from one table and insert it into the first column of excel file. Then, I need to retrieve other data from another table and transfer them into second, third and fourth column of excel file. How can I do this? Can someone provide guidelines for me? Thank you. |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2004-09-29 : 05:00:36
|
| It sounds like you may just be able to specify a query as the source of your transformation and map the columns to those in the Excel destination as required. However, without a clearer definition of the problem, it's impossible to say.Mark |
 |
|
|
|
|
|
Export Data to Excel 2000