View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sisyphus sisyphus is offline
external usenet poster
 
Posts: 2
Default Is there a CopyToRecordset (Oppisite of CopyFromRecordset)

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.