ADO Recordset To Access Table

"socajam" <socajam.DeleteThis@yahoo.com> wrote in message news:<0489b9fa525990fede485b5256773f3d.DeleteThis@localhost.talkaboutprogramming.com>...
 > Help... I need some assistance with this. I normally manipulate data on a
 > SQL Server with ADO and stored procs. This time I have to dump the data
 > from an ADO recordset, into an Microsoft Access table. All the code is
 > written and I have the recordset available, but I can't figure out how to
 > put it into an Access table.

loop through the recordset and build insert statements or open a
second recordset from the access table and do AddNew and copy the
values... I don't think there's any way to just re-direct the
recordset object and have access save it.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: ADO Recordset To Access Table 

On 11 Jun 2004 07:57:09 -0700, butlerbob.RemoveThis@earthlink.net (Bob Butler)
wrote:

 >"socajam" <socajam.RemoveThis@yahoo.com> wrote in message news:<0489b9fa525990fede485b5256773f3d.RemoveThis@localhost.talkaboutprogramming.com>...
  >> Help... I need some assistance with this. I normally manipulate data on a
  >> SQL Server with ADO and stored procs. This time I have to dump the data
  >> from an ADO recordset, into an Microsoft Access table. All the code is
  >> written and I have the recordset available, but I can't figure out how to
  >> put it into an Access table.
 >
 >loop through the recordset and build insert statements or open a
 >second recordset from the access table and do AddNew and copy the
 >values... I don't think there's any way to just re-direct the
 >recordset object and have access save it.

Maybe you could persist the data to disk XML and then read it into a
recordset that is connected to the MS Access database, and write it
using .UpdateBatch()?

Something I've done in the past is save some data to CSV format and
then re-read it using Excel, so the principle might work. Sometimes
the CSV format saves you from grief with incompatible data types.

Has looping through one recordset and doing an ".AddNew" in the other
already been tried?

Related information, from a fragment of the past:

<article>
When importing data in DTS or ADO, from Paradox to SQL, if it's a
problem try the following equivalents, even though they aren't
equivalent:

Paradox Type SQL Type to use
------------------ --------------------------
I (Integer) float
S (Small int) smallint
A (Alpha) nvarchar
D (Date) smalldatetime
@ (Timestamp) nvarchar(24)
L (Logical) nvarchar(1)
</article>

_______________________
Michael B. Johnson<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: ADO Recordset To Access Table