I am looking for a simple example of Excel opening an MS Access database,
finding a row by the primary key, writing a value to one of the fields and
then closing the database.

Does anyone have such an example and/or know of where an example might be?

TIA.

I don't think this link has that specific example, but it has some good
background and "points the way"

http://www.erlandsendata.no/english/...php?t=envbadac
Mr. Erlandsen's site on ADO.

--
Regards,
Tom Ogilvy

"Karl" wrote in message
...
I am looking for a simple example of Excel opening an MS Access database,
finding a row by the primary key, writing a value to one of the fields and
then closing the database.

Does anyone have such an example and/or know of where an example might be?

TIA.

"Tom Ogilvy" wrote ...

I am looking for a simple example of Excel opening an MS Access database,
finding a row by the primary key, writing a value to one of the fields and
then closing the database.

I don't think this link has that specific example, but it has some good
background and "points the way"

http://www.erlandsendata.no/english/...php?t=envbadac
Mr. Erlandsen's site on ADO.

The OP requires the UPDATE sql syntax e.g.

UPDATE MyTable SET MyDataCol = 'New Value' WHERE MyKeyCol = 55;

Jamie.

--