I posted this under another Excel question and it works pretty slick. You can apply formatting (Inserting rows, Titles, formatting to the detail, etc) to the excel file and it will be maintained even after the excel table is dropped and recreated.

================================================================

Use an Execute SQL task against the Excel connection:

DROP TABLE table_name

Then In a second Execute SQL task against the same connection:

CREATE TABLE `table_name` (

`ColumnName1` VarChar (8) ,

`ColumnName2` DateTime )

You can also apply formatting to this Excel file after the first load and it will maintain the formatting even with the DROP and CREATE.

Hope this helps.

-Corey

================================================================