View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adax Adax is offline
external usenet poster
 
Posts: 12
Default ADODB: duplicates -problem

Hello, I have problem with auto-separating duplicates records by PrimaryKey
i Access table.
Dim conn As ADODB.Connection
conn.Execute "INSERT INTO Tabele1.....", p1, p2
Is it possible set the p1 & p2 parameters for this?

I want to have similary solution, that in DoCmd.RunSQL, where is
auto-separating duplicates records:
DoCmd.SetWarnings False
DoCmd.RunSQL "INSERT INTO Tabele1.....", -1
DoCmd.SetWarnings True

Help me, please, Thanks!