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 |
|
klingdon74
Starting Member
2 Posts |
 Posted - 2007-08-20 : 02:15:04
|
| Just by using SQL Server 2000, what's the best way to run a stored procedure outputing the results to an excel sheet? I don't have Crystal Reports or any other 3rd party reporting tool to help me, a restriction of our client. Found this [url]http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1057989,00.html[/url] sp_write2Excel. Would this be the best way? Any other methods? The SQL server does not have MS Office so I think I need to ouput to a csv file. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-20 : 21:57:22
|
| You can call sp with osql. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Report generation in sql server 2000