我做了一个将excel导入到MSsql的功能,百十来条数据还行,过万条很慢,有没有更快速的导入方法?
<%
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 "导入成功"
end if
%>
<%
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 "导入成功"
end if
%>