28,409
社区成员




'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''加ID编号
set conn4=CreateObject("ADODB.Connection")
conn4.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Extended properties=Excel 5.0;Data Source="&Server.MapPath("Edit\"&ExcelFile)&""
exec="select id from [学生信息$]"
set rsa=server.createobject("adodb.recordset")
rsa.open exec,conn4,1,1
do while not rsa.eof
l=l+1
sql="update [学生信息] set id ='"&l&"' where id ='"&rsa(0)&"'"
'response.write sql&"<br>"
conn4.execute(sql)
rsa.movenext
loop
rsa.close
rs.close
conn4.close
conn.close
set rsa = Nothing
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
i=i+1
y="A"&i
sql="update [学生信息$] set id ="&y&" where id ="&rsa(0)
<%
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''加ID编号
set conn4=server.CreateObject("ADODB.Connection")
conn4.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Extended properties=Excel 5.0;Data Source="&Server.MapPath("Edit\"&ExcelFile)&""
exec="select id from [学生信息$]"
set rsa=server.createobject("adodb.recordset")
rsa.open exec,conn4,1,1
i=0
do while not rsa.eof
i=i+1
sql="update [学生信息$] set id ="&i&" where id ="&rsa(0)
conn4.execute(sql)
rsa.movenext
loop
rsa.close
rs.close
conn4.close
conn.close
set rsa = Nothing
%>