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.

Who is Participating?
DTS you can find in Enterprise manager.  In DTS you have to make your excel with your query-result.

Wtih the tasks you can do diffrent things, sql, script ..... send mail with attachement (if your server allows mail).
Exporting to excel, sounds like something you do with DTS (SQL 2000) or SSIS (SQL2005/SQL2008).
nakulaminAuthor Commented:
how can i use DTS with that....
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.