Maybe using two connection....

like this:

' conn1: connection to OO4O
' conn2: connection to MSAccess
' rs_recordset: the query to OO4O

Do while not rs_recordset.EOF

strSQL = "insert into table1 values (" & rs_recordset(0) & ", " &
rs_recordset(1) & ");"
conn2.execute strSQL

rs_recordset.movenext
Loop


this is the pseudo code... the idea is the same...

gbaltazar



From: "jeanie" <jnyh1971@...>
Reply-To: oo4ole@yahoogroups.com
To: oo4ole@yahoogroups.com
Subject: [oo4ole] Re: Oradynaset into MS Access
Date: Tue, 24 Feb 2004 15:42:54 -0000

--- In oo4ole@yahoogroups.com, "arteaga7" <arteaga7@h...> wrote:
> Greetings
>
> How can I create an MS Access table from an Oradynaset in VBA? An
> Oradynaset is an Oracle Object for OLE (OO4O). I have a VBA module
> that connects and runs a query from Oracle and gets the data into
an
> Oradynaset. Now I need to get this data into an MS Access table.
>
> Thanks
> Sam Arteaga
Hi,

I don' know how to create one neither. However, I use a trick of
appending data to an existing Access table. If you are interested in
it. Let me know. Jeanie :-)

_________________________________________________________________
MSN. Más Útil Cada Día http://www.msn.es/intmap/