export sql query result to excel spread sheet

Hi,,
I need to export a sql query result to a excel sheet. I can't use DTS. Any
simple t-sql code to do this?
ThanksHI
see this link
http://weblogs.sqlteam.com/mladenp/...7/25/10771.aspx
regards
Vt
Knowledge is power;Share it
http://oneplace4sql.blogspot.com
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uLo2uU0tHHA.3944@.TK2MSFTNGP06.phx.gbl...
> Hi,,
> I need to export a sql query result to a excel sheet. I can't use DTS. Any
> simple t-sql code to do this?
> Thanks
>
>|||it works,
Thanks a lot!!!!~
\\
"Vt" <vinu.t.1976@.googlemail.com> wrote in message
news:u52BIE1tHHA.1728@.TK2MSFTNGP06.phx.gbl...
> HI
> see this link
> http://weblogs.sqlteam.com/mladenp/...7/25/10771.aspx
> regards
> Vt
> Knowledge is power;Share it
> http://oneplace4sql.blogspot.com
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:uLo2uU0tHHA.3944@.TK2MSFTNGP06.phx.gbl...
>