Help copying an array into an ADO recordset

From: rotor (anonymous_at_discussions.microsoft.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 12:36:05 -0700

Hello, I'm using VBA in Win 2k with Office XP.

I have an array of data that has been crunched that I would like to copy into an ADO recordset. I'm not sure where to begin. For instance, can you just open an empty recordset and then write data into it? How?

If someone has a function to do this could you please post example VBA code? I'm presuming that this process is the same regardless of App (i.e. whether working in Excel or Access?).

Thanks in advance for the assistance.

Relevant Pages

  • Re: Creating a recordset over a range
    ... You can put the range in an ADO recordset, or so I've heard, but I also hear ... in an array and looping through the array instead of the range. ... James wrote: ... > I need to create a recordset over an excel range and use bits of it ...
    (microsoft.public.excel.programming)
  • Re: Multi-Language Site
    ... ' Reset filter ... without having to change the pages that use the translations. ... doesnt matter if this data comes from an ADO recordset, an array, or an XML ...
    (microsoft.public.inetserver.asp.db)
  • ordinal position of fields in ado recordsets
    ... I want to populate an array with values from an ado recordset ... dim Fld as Field ... dim intfieldmarker is integer ...
    (comp.databases.ms-access)
  • Help copying an array into an ADO recordset
    ... I have an array of data that has been crunched that I would like to copy into an ADO recordset. ... I'm presuming that this process is the same regardless of App (i.e. whether working in Excel or Access?). ...
    (microsoft.public.access.queries)
  • Re: Bound chart to ado recordset
    ... I no longer use the charting ... I would like to bound the row source to ADO Recordset. ... Dim rec As ADODB.recordset ... Excel range. ...
    (microsoft.public.access.formscoding)