<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sql="select * from excel"
rs.open sql,conn,1,1
response.ContentType ="application/vnd.ms-excel"
%>
<table width="650" border="1">
<tr>
<td>id</td>
<td>a</td>
<td>b</td>
<td>c</td>
</tr>
<% while not rs.eof %>
<tr>
<td><%= rs("id") %></td>
<td><%= rs("a") %></td>
<td><%= rs("b") %></td>
<td><%= rs("c") %></td>
</tr>
</table>
<%
rs.movenext
wend
rs.close
set rs=nothing
%>