if Not RS.EOF Then
Dim F, Head
For Each F In RS.Fields
Head = Head & ", " & F.Name
Head = Mid(Head,3) & vbCrLf
Response.ContentType = "text/plain"
Response.AddHeader "Content-Disposition", "attachment;filename=Orange_Mob_CostCentre_Itemise d_" & Request.QueryString("RQ") & ".csv"
Response.Write RS.GetString(,,", ",vbCrLf,"")
Response.Redirect "OrangeExcelReportRequestError.asp?E=CCI&R="& strRequest &""
Hope some can till me if it is possable or not and if it is point me in the right direction
You can't do it with a csv as it is not a spreadsheet as such, just a text file format that Excel and read and understand and present in a spreadsheet format.
It theory you could use the Excel objects to create a spreadsheet though. You would need to have these installed on your server though. And you would need to do a bit of work to get it all going.... but in theory it would work.