UC知道ASP将数据导入数据库的问题？
来源：百度知道 编辑：UC知道 时间：2024/05/26 04:10:51
<form method="post" name="a" action="12.asp">
<table>
<%
dim conn2
set conn2=CreateObject("ADODB.Connection")
conn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Extended properties=Excel 5.0;Data Source=E:\AspTest\DataBase\a.xls"
sql = "select * FROM [Sheet1$]"
set rs = conn2.execute(sql)
do while rs.eof=flase
cate=rs("cate")
bid=rs("bid")
id=rs("id")
%>
<tr>
<td><input type="checkbox" name="a" id="a">
<td><%=id%></td>
<td><%=cate%></td>
<td><%=bid%></td>
</tr>
<%
rs.movenext
loop
rs.Close
conn2.close
set conn2 = nothing
%>
</table>
<input type="submit" nam
<table>
<%
dim conn2
set conn2=CreateObject("ADODB.Connection")
conn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Extended properties=Excel 5.0;Data Source=E:\AspTest\DataBase\a.xls"
sql = "select * FROM [Sheet1$]"
set rs = conn2.execute(sql)
do while rs.eof=flase
cate=rs("cate")
bid=rs("bid")
id=rs("id")
%>
<tr>
<td><input type="checkbox" name="a" id="a">
<td><%=id%></td>
<td><%=cate%></td>
<td><%=bid%></td>
</tr>
<%
rs.movenext
loop
rs.Close
conn2.close
set conn2 = nothing
%>
</table>
<input type="submit" nam
在<input type="checkbox" name="a" id="a">中添加value，如：
<input type="checkbox" name="a" value="<%=id%>">
12.asp里：
<%conn2设置为excle连接，conn设置为access连接
a=request("a")
sql = "select * FROM [Sheet1$] where id in ("&a&")"
set rs = conn2.execute(sql)
do while not rs.eof
conn.execute("insert into 【表名】([id],[cate],[bid]) values('"&rs(0) &"','"& rs(1) &"','"&rs(2)&"')")
rs.movenext
loop
在<input type="checkbox" name="a" id="a">中添加value，如：
<input type="checkbox" name="a" id="a" value="<%=id%>">
12.asp:
<%
dim conn2
set conn2=CreateObject("ADODB.Connection")
conn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Datab