Export Recordset Data to CSV Using ASP

This simple ASP/VBScript code sample shows how you can export data from a database table to a CSV file without using any components or database drivers. The script accesses the table through an ADODB Recordset object, converts the values into the CSV format and sends the data to the browser along with appropriate response headers. This code should be saved as an ASP script on a webserver. You should see an "Open/Save As..." dialog when you access the script through a web browser.