利用err对象: sql="insert into table(f1,f2) values('v1','v2')" conn.execute sql if err.number<0 then response.write "出错了:"& err.description err.clear else response.write "OK" end if [ 查看全文 ]
Public Sub distinctCount() '求Col列中StartRow到EndRow范围中不重复的个数 '本例是计算标题为sheet1的Excel表中的A1:A240的不重复值的个数 '修改下面四行的结尾值 Dim sheetsCaption As String: sheetsCaption = "Sheet1" Dim Col As String: Col = "A" Dim StartRow As Integer: StartRow = 1 Dim EndRow As Integer: EndRow = 240 '以下固定 Dim Count As Integer: Count = 0 With Sheets(sheets...[ 查看全文 ]