PROBLEM TO STORE DATA IN DB ACCESS

• • Reply

  13 years ago

  by nikos

  nikolas

  , Greece

  Joined 14 years ago

  Hi  friends

  I HAVE A PROBLEM AND NEED HELP

  I HAVE A BASE OF DATA WITH THREE TABLES

  IN THE FIRST TABLE AND IN SECOND I STORE THE DATA WHICH HIM I READ FROM A FILE I COMPARE THE DATA BETWEEN THEM AND I WANT HIM TO STORE IN THE THIRD TABLE. I HAVE REACHED IN THE STEP TO COMPARE THE DATA AND I NEED HELP AFTERWARDS THE COMPARISON HIM TO STORE. SOMEWHERE MAKE ERROR   SOME DOES HELP?

  sql2 = "SELECT lnlc.dn, kalod.dn, kalod.kk, kalod.kv, kalod.box FROM kalod INNER JOIN lnlc ON kalod.dn=lnlc.dn;"
  Set rst2 = dbCUST.OpenRecordset(sql2)
  Do While Not rst2.EOF       If rst2!lnlc.dn <> "" Then
      Debug.Print rst2!lnlc.dn
          Else
      rst2.MoveNext
          End If
  Loop
  
  
  
  
  
  
  

   

  NIKOS

  Report abuse
• • Reply

  13 years ago

  by addi82

  Aditya Singh

  Lucknow, India

  Joined 14 years ago

  Hi Nikos,

  Please more specify your problem. If the problem is "duplicate data", then use nested query. "Select * from tablename1 where field1 in (select * from tablename2)."

  Hope this would help you.

  Regards,

  Aditya

   

   

   

  Report abuse