Exporting the output of a stored proc. to excel

Question

I want to export the result of a stored procedure execution to a excel worksheet,I want to set this up as a Job which will generate the result and store it in a excel worksheet.Is this possible I have googled it but not found any convincing workable solutions

Scheduled SSIS package, see http://stackoverflow.com/a/87772/246342 — Alex K., Jun 24 '14 at 11:39

Saber · Accepted Answer · 2014-06-27T10:17:00.180

1

You can use INSERT INTO OPENROWSET, for example:

INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\Output.xls;', 'EXEC   [dbo].[spName] ''param''') EXEC [dbo].[spName] 'param'

You should enable Ad Hoc Distributed Queries before:

EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE
GO

edited Jun 27 '14 at 10:17

answered Jun 24 '14 at 11:42

Saber

2,440
1
25
40

Can I specify a execute statement in place of select here! – joel Jun 26 '14 at 05:24

Exporting the output of a stored proc. to excel

1 Answers1