I want to insert rows into an Acess table.
In DAO, I don't have to bother checking if some of the rows were already there: I only had to use docmd.setwarnings=false before the docmd.runSQL.
Now, I vave to use ADO for many reasons. When I execute the command, I get an error 80004005 saying that because some of the rows are already there the inserts are not made.
Because the query is already very complex, I would rather not elminiate myselg those double rows.
Is there any property or method I can use on the connection or the command to force ADO to insert the new rows and forget about the others?