Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Export Result Set to Excel with Format Expand / Collapse
Author
Message
Posted Wednesday, October 9, 2013 3:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 1:03 AM
Points: 40, Visits: 68
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.
Post #1502980
Posted Wednesday, October 9, 2013 3:21 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 13,724, Visits: 10,680
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1502984
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse