+ -
当前位置:首页 → 问答吧 → recordcount 不能大于2

recordcount 不能大于2

时间:2011-08-07

来源:互联网

用excel读取Access,单无论有多少记录,recordcount 都是1
For rowexcel = 2 To lastrow        '数据从第三行开始
'If rowexcel = 103 Then Stop
    'rs1.Open "select * from T_individual_addressbook where T_individual_addressbook.PersonalName='" & Cells(rowexcel, 2) & "'", conn, 1, 3
    rs1.Open "select * from T_individual_addressbook where '" & Cells(rowexcel, 2) & "' like T_individual_addressbook.PersonalName ", conn, 1, 3
    If rs1.RecordCount >= 2 Then  '判断该值是否重复
        errorsign = 1
    End If
    Set rs1 = Nothing
    'rs1.Close
Next rowexcel

我用2003office
请那位可以回答

作者: charliemailbox   发布时间: 2011-08-07

条件好像写反了:
rs1.Open "select * from T_individual_addressbook where T_individual_addressbook.PersonalName like '" & Cells(rowexcel, 2) & "'", conn, 1, 3

作者: zhaogang1960   发布时间: 2011-08-07