<html>
<head>
<title>上傳文件</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css/css.css" rel="stylesheet" type="text/css" />
</head>
<script>
if (top.location==self.location)
{
top.location="index.asp"
}
</script>
<body leftmargin="0" topmargin="0">
<table width="100%" border=0 cellspacing=0 cellpadding=0>
<form name="form" method="post" action="readxls.asp" enctype="multipart/form-data">
<tr>
<td>
<input name="file1" type=file class=input-text size="30">
<input type=submit name="submit" value="導(dǎo)入數(shù)據(jù)" style="width:70px; height:19px;" >
</td>
</tr>
</form>
</table>
</body>
</html>
--------------------------------------
-------上傳并且寫入庫(kù)-----------
readxls.asp
'上傳XLS文件結(jié)束，下面從上傳的XLS文件中讀取數(shù)據(jù)寫入到SQL數(shù)據(jù)庫(kù)
strAddr=server.MapPath("uploadfile/"&filename)
set excelconn=server.createobject("adodb.connection")
excelconn.open "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = "+strAddr+";Extended Properties='Excel 8.0;HDR=NO;IMEX=1'"
set rs=server.CreateObject("adodb.recordset")
set rs1=server.CreateObject("adodb.recordset")
sql="select * from [Sheet1$]"
rs.open sql,excelconn,1,1
if not(rs.bof and rs.eof) then
rs.movenext
do while not rs.eof
sql1="select * from [Fees_Asse_T] where id is null"
rs1.open sql1,conn,1,3
rs1.addnew
rs1("Cate_Code")=rs(0)
rs1("Asse_Code")=rs(1)
rs1("Asse_Name")=rs(2)
rs1("Categories")=rs(3)
rs1.update
rs1.close
rs.movenext
loop
end if
rs.close()
set rs=nothing
set rs1=nothing
excelconn.Close()
set excelconn=nothing
conn.close()
set conn=nothing
%>
<script>
alert("數(shù)據(jù)導(dǎo)入成功！");
window.parent.document.location.reload();
history.back();
</script>
</body>
</html>
本站僅提供存儲(chǔ)服務(wù)，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請(qǐng)
點(diǎn)擊舉報(bào)。
