Hi,
I created a package that exports data to an excel file. I formatted the
excel file so that the first column will have the table names (changes using
"as" in select statement) as column header and I changes the back color to
blue. My package creates the header and enters the data correctly except for
one problem. All the rows entered takes the same back color as the header
(blue). How can I set this so that my dts package, after creating the column
header (using a create table clause) will not use the format form the column
header for the other rows?

I have searched the entire help file on excel because I think that has to be
turned off on excel since I tried inserting a row manually in excel after the
column header and it takes the format of the first (row above) row.

Thanks