以下是我很久以前写的,肯定行。
If Trim(cmbLocation.Text) <> "" Then
adoRst.Open "SELECT location FROM Location WHERE location='" & Trim(cmbLocation.Text) & "'", adoCn, adOpenKeyset
If adoRst.EOF Then
adoCn.Execute "INSERT INTO Location VALUES('" & Trim(cmbLocation.Text) & "','')"
End If
adoRst.Close
End If