How to export resultset data to excel using sqlserver?

Question

How to export resultset data to excel using sqlserver? i have written one stored procedure using joinsmy requirement isexport that result set data to excel in single procedure Thanks inadvance

srinivas P · Answer

it is not working in sqlserver2008?

Prabhu Raja · Answer

Hi srinivas We can do this by following USE MYDATABASE INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0' 'Excel 8.0;Database=d:\SqlServer2Excel.xls;''Select * from [sheet1$]') SELECT * FROM TableA And i saw a procecure on net i think it will match your need. Click the Link to see Procedure - ------------------------------------------------ If it helps you then mark as Correct answer