How to insert text into an Excel file from a sql server database

[Rettla]

I am working on a website and there is a need to export details that are stored on the database and put them in an excel file. I need to format the text such that each value appears in its own cell in that row. Right now they are all just appearing in one cell in that row.

The code I am using is shown below. The website is in classic ASP

' Bulk Excel CSV export
 
If intShowPhoto = 5 then
   Response.ContentType = "text/csv"
    Response.Charset = "utf-8"
    Response.AddHeader "Content-Disposition", "attachment; filename=Bulk_Exports.csv"
    Do While Not objRecordset.EOF 
    If objFirstName <> "" Then
            Response.Write(objFirstName)
            Response.Write("      ")
            End If
 
            If objSurname <> "" Then
            Response.Write(objSurname)
            Response.Write("     ")
            End If
     If objTelMobile <> "" Then
            Response.Write(objTelMobile)
            Response.Write("     ")
 
        End If
        If objEMail <> ""  Then
           Response.Write(objEMail)
           Response.Write(vbCRLF)
 
        End If
 
        objRecordset.MoveNext
    Loop            
    Response.End                
End If
 

[Rabbit]

That's because you haven't added any delimiters.

[Rettla]

how do i add those i am still new to vbscript

[Rabbit]

You just need to write a comma after each field for a comma delimited file. Or a tab or a tab delimited file. Except at the end where you write a new line.

Also, it looks like you're not writing the new line if the email is a blank string. You have to write the new line no matter what.

And it looks like you're writing variables rather than the values in the recordset. That would be okay if you populated the variables with the values in the recordset but you don't do that.

[Rettla]

I did just that and it worked Thanks a lot I reali appreciate it

[Rabbit]

No problem, good luck.