convert query result to excel file and emailing using xp_sendmail

Is there any way I can convert my query result to excel file and email that using xp_sendmail.


nakulaminAsked:
Who is Participating?
 
jogosCommented:
DTS you can find in Enterprise manager.  In DTS you have to make your excel with your query-result.  
http://support.microsoft.com/kb/319951

Wtih the tasks you can do diffrent things, sql, script ..... send mail with attachement (if your server allows mail).
0
 
jogosCommented:
Exporting to excel, sounds like something you do with DTS (SQL 2000) or SSIS (SQL2005/SQL2008).
0
 
nakulaminAuthor Commented:
how can i use DTS with that....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.