ASP更新两上ACCESS表的问题

set rs=server.createobject("adodb.recordset")
sql="select * from 3 order by id"
rs.open sql,conn,1,1
do while not rs.eof
sql="Update 1 set sheet1姓名='"&rs("姓名")&"',银行帐号='"&rs("银行帐号")&"' where 姓名='"&rs("姓名")&"' and sheet1姓名<>"""
Conn.Execute(sql)
rs.movenext
loop
rs.close
response.write"完成"

set rs=server.createobject("adodb.recordset")
sql="select * from 3 order by id"
rs.open sql,conn,1,1
do while not rs.eof
sql1="Update 1 set sheet1姓名='"&rs("姓名")&"',银行帐号='"&rs("银行帐号")&"' where 姓名='"&rs("姓名")&"' and sheet1姓名<>"""
Conn.Execute(sql1)'注意这裏咦,SQL语句混了
rs.movenext
loop
rs.close
response.write"完成"

set rs=server.createobject("adodb.recordset")
sql="select * from 3 order by id"
rs.open sql,conn,1,1
do while not rs.eof
sql2="Update 1 set sheet1姓名='"&rs("姓名")&"',银行帐号='"&rs("银行帐号")&"' where 姓名='"&rs("姓名")&"' and sheet1姓名<>"""
Conn.Execute(sql2)
rs.movenext
loop
rs.close
response.write"完成"