'原理是比较简单 的//'set rs = conn_m.execute("select * from report where report_id 'like '%"& strreportid &"%'") '你用模糊搜索在这里不合理的.这样会把一些有相关字的东西也写不进来..'如果库里已有:小明...那么:小,,,这个也就写不进来了set rs=server.createobject("adodb.recordset")sql="select * from report where report_id='"&strreportid&"'" 要这样.rs.open sql,conn,1,1 '打开数据库if not rs.bof and not rs.eof then '如果数据库里有同样记录就提示response.write "重复了"else'写进数据库里 20210311
private sub worksheet_change(byval target as range) 'worksheet的change事件dim xlsheet as worksheetset xlsheet = workbooks(源文件名).worksheets(源工作表名)if target.column = 1 then for i = 1 to 100 i...