asp 導(dǎo)航excel數(shù)據(jù)到mssql access mysql 等數(shù)據(jù)方法_ASP圖文說明教程

下面是一段簡(jiǎn)單的由asp導(dǎo)入excel數(shù)據(jù)保存到其它的數(shù)據(jù)如有mssql access mysql 等哦，好了費(fèi)話不說多了來(lái)看看下面的代碼吧。

<!--#include file="adoconn.asp"-->
<%
Set xlsconn = server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")

source1=server.mappath("..")&""&replace(request("path"),"/","")
myConn_Xsl="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &source1& ";Extended Properties=Excel 8.0"
xlsconn.open myConn_Xsl

sql="select * from [商品列表$]"
set rs=xlsconn.execute(sql)
if not rs.eof then
while not rs.eof
names=rs("商品名")
pic=rs("圖片")

sql="insert into [product](namese,pic) values('"& names &"','"& pic &"')"
conn.execute(sql)

rs.movenext
wend

end if
response.write "導(dǎo)入成功"
end if
%>

數(shù)據(jù)連接文件<!--#include file="adoconn.asp"-->

set rs=server.CreateObject("adodb.recordset")
db="../database/db11.mdb"
set conn=server.CreateObject("adodb.connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
conn.open connstr