hi,
trying to update and append and the same time is dangerous
and is not recommended. they should be run as seperate
operations.

-----Original Message-----
Hello,

i use an Access database for my Excel application i'm
exporting some data
into it. I use ADO functions to insert or update data.
But i would like to know how to tell my function to
insert if the primary
key doesn't exist and to update data if it exists.

Many thanks !
.