Generate XLS from SQLServer with colors & formulas

[Sparky]

Context:
Web Front End controlling piping of data
SQL Server Source
Excel 2003 SP2 destination
Push colors and embed formulas not just cells
ASp not ASPx preferred
zBeen done with MSODSC but need ADO or better connection
Using studio 2003
XML intermediate OK