Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Export table data to Excel file

Author  Topic 

aksana
Starting Member

13 Posts

Posted - 2008-08-01 : 01:12:19
hi,
I would like to ask about whether I can marge cell or color cell itself when exporting.
for example,

TBL_NAME Name.xls
first last age name age
aksana riz 34 ???? adksana riz 34
miley stew 16 export to Excel miley stew 16

Name.xls will have a "name" field which color is green.

or I need to make Excel Macro to do that??

thank you,
aksana

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-01 : 13:10:56
Not sure you can do this from ssis. may be you can try writing a script component trying to manipulate excel properties.
Go to Top of Page
   

- Advertisement -