output data from the result of storedprocedure into excel format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using asp.net(2003). I would like to output the data from the result of
storeprocedure (sql 2000 server) into excel format. (office 2003) Can I do
that?
Please show me the coding if it can.
 
Hello,

I don't ahve any code because I haven't done any ASP.Net. However, I would
think that when you place the results into a dataset or recordset, all you
have to do is create an Excel object and 'load' the data into the worksheet.
When done, use the saveas method to save the workbook where you want it.

I done things like this is VB script, so I would think it is easily done is
ASP.Net.

Hope this helps.
 
Back
Top