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 |
|
akpaga
Constraint Violating Yak Guru
331 Posts |
 Posted - 2010-01-29 : 17:55:11
|
| I need to export a view to excel or csv file with the headers and place them in a specific path.Intially i was using madhivanans post[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926[/url]but after an upgrade to sql server 2005 the procedure is not working?Please help thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-30 : 00:50:27
|
| If you were using procedure that uses xp_cmdshell, make sure its enabled. SQL 2005 has it disabled by default so you need to enable it after going to surface area configurationhttp://www.mssqltips.com/tip.asp?tip=1020 |
 |
|
|
akpaga
Constraint Violating Yak Guru
331 Posts |
Posted - 2010-02-01 : 10:05:31
|
| thanks visakh16 for your response..but there are already sp's that use xp_cmdshell in the databse.The excel file is created but with no data in it. |
|
|
|
|
|
|
export to excel or csv with headers