ADO from Oracle to Access

[mark]

Hi.

I need a way to get some data from an Oracle table into an Access table.

(I looked at linking the table, but it seemed to take a long time that way).

I've used ADO to put data into an Excel Pivot Cached, so I know the various
database connection strings, etc. from that.

What I need to know is if there's a way to take a recordset, and create an
Access table from it?

Or, some equivalent...

Thanks.

 

[Stefan Hoffmann]

hi Mark,

I need a way to get some data from an Oracle table into an Access table.
(I looked at linking the table, but it seemed to take a long time that way). Huh?

What I need to know is if there's a way to take a recordset, and create an
Access table from it?

You can only loop through it and append each record manually, e.g.
something like

While Not rsOra.Eof Do
rsAcc.Add / Append
rsAcc!Fields == rsOra!Fields
rsAcc.Update
rsOra.MoveNext
Loop

Or, some equivalent...

Consider usting a passthrough query as source for an append query.

mfG
--> stefan <--

 

[mark]

Thanks, Stefan,

I'm very experienced in Excel, but not in Access. In Excel, you can
directly take an ADO recordset and assign it to be used as a Pivot Cache.

I was hoping for some similar way to assign the whole set to be a table.

But oh well. I can follow your suggestion.

Thanks.
Mark