dipankar_pr 0 Newbie Poster
  1. A access database contain one table PhBook with fields First name, Last Name, Mobile Number
  2. Few record already exist in PhBook table
  3. Mobile Number is consider as unique and appears in database once.
  4. First name and last name may duplicate.
  5. One excel contains few records in column First Name, Last Name, Mobile Number in same manner.
  6. There are few records belong in both say 10 records.
  7. There are few records belong only Access database say 100 records.
  8. There are few records belong only Excel say 20 records.
    Now I like to develop a VB6 applications which import data from excel to access only which records does not belong to access.
    I like to use ADODB.
    Database connection establish by ADODB conn and rs. Excel is open.
    Now if Mobile number does not exist in access then it need to add the record in access.
    Please help me.