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.

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.

Just getting back to this.

I do have access to the d/b. But I am generating and populating worksheets
from a template that are then sent out to be updated. I don't think I can
link the template. Also the update worksheet is generated as a new worksheet
each time (thus the use of the template). Am I missing something, or
misunderstanding your answer?

"K Dales" wrote:

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.