How to create Excel File using Sql Server

Hi,

Try this link http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

it will help.

-Pandian

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..

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:\testing.xls;',

'SELECT Name, Department FROM [Sheet1$]')

SELECT [Name], [Department] FROM employee

GO