0 If you want to import data to excel from sql server table, then you can directly do it in SQL server.
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