Merjet,

Then how to amend the code, if I need to search the records and update
exsiting one?

"merjet" wrote:

No. You need to search the records if you want to update existing
ones. The records having a primary key would make it easier to find a
match. The steps would be as follows. For each row in Excel search the
Access table. If a match is found, update the record. If a match is
not found, add a new record.

Hth,
Merjet