Friday, August 26, 2011

SQL Query to Excel with Colum Result (SQL 2005 Version)

EXEC master.dbo.sp_makewebtask
    @outputfile = 'C:\shaneesh.xls',
    @query = 'select * from [PROJECTMANAGER].[IHMS].[dbo].tbl_Admin_Car_M',
    @colheaders =1,
    @FixedFont=0,@lastupdated=0,@resultstitle='Testing details'

Result : File Create in C: drive - shaneesh.xls

No comments:

Post a Comment