注册 登录
编程论坛 ASP技术论坛

为什么我用for循环导入的数据都是第一行的?

天上的星 发布于 2009-08-28 16:10, 280 次点击
Set excconn=Server.CreateObject("ADODB.Connection")
      excStrConn= "Driver={Microsoft Excel Driver (*.xls)};DBQ="& request("file")
    excconn.Open  excStrConn
     '查询excel语句   
   
     Set excrs = Server.CreateObject("ADODB.Recordset")     
     excSql="select * from [080927$]"     
    excrs.Open excSql,excconn,2,2
                     
        set rs=server.createObject("ADODB.Recordset")         
       if request("xq")="first1" then
            sql="select * from  first1 "
      
        end if
      
        rs.open sql,conn,1,3                 
            for i=1 to 50
                rs.addnew               
                    for t=0 to 10                  
                    rs(t+1)=excrs(t)           
                    next
                    rs("time")=now()
            
                rs.update
            next
        rs.close
        set rs=nothing   
      
    excrs.close
    set excts=nothing
   
    excconn.close
    set excconn=nothing   
    conn.close
    set conn=nothing
   
        
0 回复
1