excel问题,问题解决后,20分送上
Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'
[Microsoft][ODBC Excel Driver]常见错误 不能打开注册表关键字 'Temporary (volatile) Jet DSN for process 0x5fc Thread 0x688 DBC 0x2321144 Excel'。
/lm/cc.asp,行3
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft excel driver (*.xls)};uid=admin;fil=excel 8.0;dbq=" & server.mappath("aaa.xls")
sql="select * from [sheet1$]"
set rel=conn.execute(sql)%>
<html>
<body>
<table>
<% do while not rel.eof %>
<tr>
<td width=100><%=rel("id")%></td>
<td width=100><%=rel("name")%></td>
<td width=100><%=rel("tel")%></td>
<td width=100><%=rel("address")%></td>
</tr>
<% rel.movenext
loop
%>
</table>
</body>
</html>