Post reply

SQL Server Job to Excel

  • April 15, 2009 at 4:53 am

    #75457

    Hi All,

    Is there any possibility to load the result of a Job to a Excel sheet, and that excel sheet should contain the all columns which will get when we ran the query in QA.

    I have tried it by giving the a path for excel sheet in Job results, but the result contain in only one column.

    Thanks in Advance

    Thank You.

    Regards,
    Raghavender Chavva

  • April 15, 2009 at 7:21 am

    #978051

    Do a search on exporting to Excel file using OPENROWSET and you should find a solution to your question.

  • April 17, 2009 at 7:48 pm

    #980096

    Create an Excel file named testing having the headers same as that of table columns and use these queries

    1 Export data to existing EXCEL file from SQL Server table

    insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',

    'Excel 8.0;Database=D:\testing.xls;',

    'SELECT * FROM [SheetName$]') select * from SQLServerTable

    MJ

  • April 18, 2009 at 3:13 pm

    #980257

    Thank you for your help.

    Now I am able to do it.

    Thank You.

    Regards,
    Raghavender Chavva

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply