Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hameed
Starting Member
40 Posts |
 Posted - 2001-10-28 : 09:45:34
|
| Hi on a website, I have a form with several fields that are basically drop down lists pulled from a sql server db. The user then selects various values from all the drop downs, I then join everything together in a a stored procedure and return records from a table in the db back to the browser. Is there any way I can also kick off a stored procedure (or whatever method) to generate an excel file of the same returned data set that will then be available to the person making the inquiry on the website - either as a link or maybe sent as an email. I am pulling out my hair about how to do this. First off, I don't know how to set up a procedure to do the export of the data, and secondly I don't know how to get the excel file to the visitor on the site. Please help |
|
|
|
|
|
programmatically exporting data to excel