writing cell contents to Access Database

[lushl0sn]

Hi Folks

I'm looking for a complete working example of how to write a single cell to a Access table using a SQL command.
More to the point, i'm looking to UPDATE an access table field with a certain record ID with the current contents of a cell. I am using Excel 2003.

I would be most thankful you give you permission to marry my daughter.

Thanks in Advance

[yawnzzzz]

Here's an example I found that's commented pretty well.

Please Login or Register  to view this content.

[Kenneth Hobson]

Row 1 contains the fieldnames. Row 2 contains the data. If you are adding one record for one field value, add the field name in some scratch sheet area and the value in the cell below it and name the range to pass.

One wife is a handful as it is...

Please Login or Register  to view this content.

[Kenneth Hobson]

Here is another method using Update. Update is needed to update the MDB as the recordset is disconnected until then. AddNew is used to add a new record.

Please Login or Register  to view this content.

[lushl0sn]

Thanks Guys!

You are the best!!!
The examples worked and I can leave work happy!