View Single Post
  #2 (permalink)  
Old December 30th, 2005, 01:07 AM
David_the_DBA David_the_DBA is offline
Friend of Wrox
Join Date: Dec 2005
Location: , AZ, .
Posts: 146
Thanks: 0
Thanked 1 Time in 1 Post

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
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

David Lundell
Principal Consultant and Trainer