Re: Newbie : Oracle data to Access table.

"General Fear" <richmarin@xxxxxxxxxxxxx> wrote in message
news:1138285226.119771.326520@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Thanks for the reply.
>
> Is it possible to do this without a link. Maybe straight VB code.
>

You can use ADO to connect to Oracle, select the data from the table,
traverse each row returned and issue an insert to Access (not a very
efficient method).

Another way could be; ADO to Oracle using a connection object, select the
data from the table into a recordset object then change the recordset
connection object to the Access one. This would require that both tables be
identical in structure. You may need to replace the command objects as
well, maybe.

--
============
Frank Hickman
Microsoft MVP
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.


.

Relevant Pages