Generate Excel From SQL Server

[vvashishta]

I want to get data of a table in to an Excel direct from a SQL Query. Can anyone help? - Happy Coding - Vishal Vashishta

[gonzalezmail1980h]

Hello, A quickly lookup in google.com, I´ve obtained this information:

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\testing.xls;',
'SELECT Name, Date FROM [Sheet1$]')
SELECT [Name], GETDATE() FROM msdb.dbo.sysjobs
GO

If you need more informtion, you can use this link: http://www.mssqltips.com/sqlservertip/1202/export-data-from-sql-server-to-excel/[^] Regards, David G. :-D