Solved

convert query result to excel file and emailing using xp_sendmail

Posted on 2008-09-30
3
465 Views
Last Modified: 2010-05-18
Is there any way I can convert my query result to excel file and email that using xp_sendmail.


0
Comment
Question by:nakulamin
  • 2
3 Comments
 
LVL 25

Expert Comment

by:jogos
ID: 22605991
Exporting to excel, sounds like something you do with DTS (SQL 2000) or SSIS (SQL2005/SQL2008).
0
 

Author Comment

by:nakulamin
ID: 22606119
how can i use DTS with that....
0
 
LVL 25

Accepted Solution

by:
jogos earned 500 total points
ID: 22606574
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

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
best counters for cpu high usage 3 30
Need some help to cast ntext to nvarchar SQL 2000 7 33
SQL view 2 27
SQL - Update field defined as Text 6 16
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question