Possibilities (imagined but not tested)
1) Use the Select FOR XML to get your data in XML then use XSLT to transform the XML to a format that excel can use and write that out -- see my reply to the topic DTS Package Fails When Scheduled in this same forum.
XML Excel format http://msdn.microsoft.com/library/de.../odc_xmlss.asp
2) Use the SELECT FOR XML WITH EXCPLICIT to transform directly to Excel XML format
3) Use the Excel COM to write the Excel file (warning: Performance will be slow and requires the Excel app to be installed on server)
4) Use 3rd party app accessible in COM that writes Excel files
Principal Consultant and Trainer