<%
var xlsPath="/xls/tempXLS.xls"; var conn1=Server.CreateObject("ADODB.Connection"); conn1.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(xlsPath)+";Extended Properties='Excel 8.0;HDR=yes;IMEX=1'"); var rs=conn.Execute("select * from table"); var field=rs(1).name; for(var i=2;i<rs.Fields.Count;i++){ field+=","+rs(i).name; } var rs1=conn1.Execute("select * from [sheet1$]"); var k=0;// var str=""; while(!rs1.EOF){ str=rs1(0); for(var i=1;i<rs1.Fields.Count;i++){ str+=",'"+rs1(i)+"'" } var sql="insert into table ("+field+") values ("+str+")"; conn.Execute(sql); rs1.MoveNext(); k++; } %> |
|