hi all,

i have a table in my SQL Server DB, i want to transform the every row in it to an Excel sheet/file,example:

table1 in DB:
fistname lastname DOB
aaaaa bbbb 28/12/2005
cccc dddd 31/2/2006
...

i want it to be in excel for every row:
firstname:aaaa
lastname:bbbb
DOB:28/12/2005
...
i want for every row a new sheet, is this possible?
hope this is clear, thanks

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


David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com