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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-17 : 21:51:09
|
Carrie writes "Hi there-
My company offers full courses over the internet, complete with tools that allow instructors to track the progress of their students. The instructor tools display reports generated by stored procedures in a SQL 7.0 database. Many of our instructors have asked to have this same data in a CSV format so that they can integrate it into their overall work book.
What I would like to do have a stored procedure that creates a desired recordset for the instructor, exports this data to a .CSV (or any other standard delimited) file, places the file in a shared directory, and returns the file name and location. I'd like to call this stored procedure from a web page (using ASP) from which the user will select parameters to send to the stored procedure; then the web page will use the returned file path to create a download link to the report file.
Is this possible? Can SQL export .CSV files on demand like this?
Thanks for any help and insight you can give me!
--Carrie"
|
|
|
|
|
|
Exporting SQL recordset to CSV format