just use getString to convert to a .CSV file and then change the content
type and response.write the stream out.
response.buffer = true
set oConn = server.createobject("adodb.connection")
set oRs = server.createobject("adodb.recordset")
set oRs oConn.execute("Select fld1, fld2 from mytable")
if not(ors.eof) then
sCSV = oRs.getString('get the correct params here)
response.contentype = "applcation/csv" ' ? correct content type ?
response.write "No Data"
if the data doesnt change that much you could consider caching to disk
also consider using XML
At 08:56 PM 8/3/2001 +0000, you wrote:
>Does anyone know how to download a recordset into a .csv file?
Author and Developer