前段时间写的。多谢一个朋友帮我找出错误。哈哈。
<!--#include file="conn1.asp"-->
<!--#include file="conn2.asp"-->
<html>
<head>
<title>数据更新</title>
</head>
<body>
<table align=center>
<%
exec="select * from [sheet1$]"
Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.Open exec,conn1,1,3
%>
<%
Set rs2 = Server.CreateObject("ADODB.Recordset")
'Set rs2.ActiveConnection = conn2
exec = "select * from shop"
'rs2.CursorType = 3 ' adOpenKeyset
'rs2.LockType = 3 'adLockOptimistic
rs2.Open exec,conn2,1,3
%>
<%
Do While Not rs1.Eof
rs2.movefirst
do while not rs2.eof
if (rs1("cid")=rs2("cid")) Then
rs2("price")=rs1("price")
end if
rs2.movenext
loop
rs1.MoveNext
Loop
rs1.Close
rs2.Close
conn1.Close
conn2.Close
Set rs1=nothing
Set rs2=nothing
Set conn1=nothing
Set conn2=nothing
response.write "记录更新完毕,请关闭本页面!"
%>
</table>
</body>
</html>