ASP - MySQL - Excel ???

HelloWorld · #1 (**permalink**) 09-28-2007, 07:16 PM

I'm just wondering whether it's possible to do this automatically? So we have table in MySQL that will be converted and updated automatically every time there's new data in the MySQL... I've seen this kind of application, but I have no clue on how do you do this? I'm talking about ASP VBScript, not ASP.NET.. Thanx a lot!!!

HelloWorld · #2 (**permalink**) 09-28-2007, 07:18 PM

I found this interesting code:

PHP Code:

  <%@LANGUAGE="VBSCRIPT" %>

<%

    ' Exporting A Table to Excel

    strConnection = "driver={MySQL ODBC 3.51 Driver};option=4;server=localhost;user=root;password=sorma;DATABASE=webstat;"

    set cn = server.createobject("adodb.connection")

    set rs = server.createobject("adodb.recordset")

    cn.open strConnection

    set rs = cn.execute("select statDate, visitors, unique_visitors from daily_visitors")

 
    response.ContentType = "application/vnd.ms-excel"

    response.AddHeader "Content-Disposition", "attachment; filename=excelfile.xls"

    response.Write("<table border=""1"">")

    do while not rs.eof

    response.Write("<tr>")

    response.Write("<td>" & rs("statDate") & "</td><td>" & rs("visitors") & "</td><td>" & rs("unique_visitors") & "</td></tr>" &  vbnewline )

    rs.movenext

    loop

    response.Write("</table>")

    cn.close

    set rs = nothing

%>