• * if the excel needs to be formatted, I would create a report in SSRS and export to Excel

    * bcp

    * SSIS

    * Import/Export wizard

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