How to create Excel File using Sql Server

Question

Hi Experts I want to create dynamically named Excel file from stored procedure through sql server. Any suggestions please !!! Thanks in Advance.

chellappan pandiarajan · Answer

Hi Try this link http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/ it will help. -Pandian

Santhosh Kumar Jayaraman · Answer

check this sp http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Shivaraj Poojary · Answer

Hi Santhosh.Thanks for the reply...This query works if the excel file already exists in a folder but I want to create a new excel file using T-sql..

Santhosh Kumar Jayaraman · Answer

If you want to import data to excel from sql server table then try this INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0' 'Excel 8.0;Database=C:	esting.xls;' 'SELECT Name Department FROM [Sheet1$]') SELECT [Name] [Department] FROM employee GO