Please mark this thread solved.

I am not sure how you added duplicate records. Actor_id is a primary key for that reason. It should have errored.

Copy the link to this thread and post a new one if you need help using Update in ADO. Most any SQL forum can provide that help. There are several Excel forum posts about ADO with Update that should suffice.