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 |
|
miranwar
Posting Yak Master
125 Posts |
 Posted - 2003-03-26 : 05:46:03
|
| Hi,I have been asked to create a weekly sales report for our user community. Using Sql server and Excel....Now i have written the Sp that returns all the weeks sales figures. Can anyone advise me the best way of populating the Excel Spreadsheet.Should i use VBA from within Excel. Or can i create some Kind of file that i can import into Excel ?Any Advice would be Appreciated |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-26 : 05:55:52
|
| What about DTS?Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
miranwar
Posting Yak Master
125 Posts |
Posted - 2003-03-26 : 06:05:53
|
quote:
What about DTS?Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey.
Can DTS be accessed through an SP |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-03-26 : 06:57:02
|
| Yes it can. The easiest way is to use xp_cmdshell to execute the DTSRun utility. |
|
|
|
|
|
|
Need advice on Report solution