【已解决】Microsoft JET Database Engine 错误 '80040e07' 标准表达式中数据类型不匹配。

        set conn=CreateObject("ADODB.Connection")
              conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Data Source=" & Server.MapPath("student.mdb")
              set conn2=CreateObject("ADODB.Connection")
              conn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Extended properties='Excel 5.0;hdr=yes;imex=1';Data Source="& Server.MapPath("upload/"&FileName)
              sql = "SELECT * FROM [出库明细$]"
              set rs = conn2.execute(sql)
              while not rs.eof  
sql = "insert into tmp_ckmx(tmp_warehouse,tmp_code,tmp_describe,tmp_num,tmp_price,tmp_price_t) values ('"& trim(fixsql(rs(2))) &"','"& trim(fixsql(rs(8))) &"','"& trim(fixsql(rs(9))) &"','"& trim(fixsql(rs(11))) &"','"& trim(fixsql(rs(12))) &"','"& trim(fixsql(rs(13))) &"')"
              conn.execute(sql)