Create speadsheet

[technotone]

Is it possible in a select statement to create a excel spreadsheet?

Thanks

Tony Mundy

 

[nigelrivett]

You can use bcp to create a .csv file which would default to being opened in excel.

You can use sp_oacreate to start excel and create, populate and save a spreadsheet.

Or use dts to do a similar thing.

Would probably be better to do this in a client app though.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[LloydDobler]

THis can be done with the SP_makewebtask function as well. It can output to html pages and xl sheets and fancies them up a bit too.