Home Forums SQL Server 2012 SQL 2012 - General Output a query as an Excel file RE: Output a query as an Excel file

  • November 17, 2013 at 1:24 pm

    #1666969

    hoolash (11/17/2013)

    Thanks mister.magoo and bitbucket! Wow, I didn't know it was so complex to do that! SQL Server being a Microsoft product (same as Excel), I believe there should have been an built-in procedure to do the export!

    I've tried a copy/paste of the query result and it seems to work till now. I will need to go through the excel file to see if it evrything's ok.

    The built-in procedure is called the import/export wizard. (which is basically SSIS behind the scenes)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP