InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 01:04:29 GMT20http://www.sqlservercentral.com/Forums/Topic1028188-391-1.aspxThank you all for your response. I will try it tomorrow.Tue, 30 Nov 2010 20:29:53 GMThydbadrosehttp://www.sqlservercentral.com/Forums/Topic1028188-391-1.aspxIf you output the format as if it were a CSV (commas and quotes), and put an xls file extension on it, Excel will open it without complaining. I've done that before.Tue, 30 Nov 2010 15:00:19 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1028188-391-1.aspxtry using xp_cmdshell to BCP the results to an XLS file. Excel might complain that it is in the wrong format but should still open the file.[code="sql"]exec xp_cmdshell 'bcp "exec database.dbo.usp_Sqlmonitor" queryout c:\temp\test.xls -c -T'[/code]Tue, 30 Nov 2010 14:54:29 GMTRobert klimeshttp://www.sqlservercentral.com/Forums/Topic1028188-391-1.aspxI don't want to depend on sql agent or ssis. I want to create the procedure to execute and result output should be in excell so that I can call this procedure into batch file.Tue, 30 Nov 2010 14:19:49 GMThydbadrosehttp://www.sqlservercentral.com/Forums/Topic1028188-391-1.aspxSSIS can create Excel files from proc output.Tue, 30 Nov 2010 12:28:51 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1028188-391-1.aspxPlease help in turning the store procedure result into excell and also to call this store procdure to batch file.The store procedure suppose is;USp_SqlmonitorTue, 30 Nov 2010 12:25:02 GMThydbadrose