Export Result Set to Excel with Format

  • Hi,

    Can anybody help me regarding exporting result set into Excel Sheet with specific format like (Border Size, Font Style, Column Heading etc..) ?

    Currently I am using BCP command to export result set into CSV, but the requirement got changed into Excel Sheet with format.

  • Using SSIS or BCP you won't achieve your requirement.

    Either you code it with .NET, or you use a macro to do the formatting.

    Another option is to create a report in SSRS and export that to Excel.

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

Viewing 2 posts - 1 through 1 (of 1 total)

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