If you have access to the database (no pun intended!) it is easier to do it
from the Access side (which you could run through automation from Excel).
Just link in your data range as a table (external data, linked not imported)
and set up update and/or append queries to find matching (or unmatched)
records and add the new info.

--
- K Dales


"sisyphus" wrote:

Looking for an elegant way to take a spreadsheet range and update certain
fields in an Access table. I'm sure I could loop through the rows and create
insert statements, but was wondering if there was something equivalent to the
oppisite of CopyFromRecordset, where an object turns a range with column
headings into a recordset.