SQL Statement INSERT INTO in Access2000 and XP

[bthayne]

With previous versions of Access when I used the execute command to insert data into a table, if a duplicate record was created the SQL statement would insert the records minus the dupes. Which is what I wanted it to do.

With ADO the statement will not execute. It does not add records to the table.

Is there a setting for the execute statement with ADO that will allow update to the table minus duplicate records?

 

[kaspi]

I would try to use goup by clause to get rid of duplicates in your SQL statement.