Re: Newbie : Oracle data to Access table.
- From: "Frank Hickman [MVP]" <fhickman3_NOSP@xxxxxxxxxxxxxxx>
- Date: Thu, 26 Jan 2006 15:34:41 -0500
"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.
.
- References:
- Newbie : Oracle data to Access table.
- From: General Fear
- Re: Newbie : Oracle data to Access table.
- From: Frank Hickman [MVP]
- Re: Newbie : Oracle data to Access table.
- From: General Fear
- Newbie : Oracle data to Access table.
- Prev by Date: Command object stops prematurely without error?
- Next by Date: Re: ADO data object using COM or assembly?
- Previous by thread: Re: Newbie : Oracle data to Access table.
- Next by thread: Re: Adding a Column fro a DataTable to Another DataTable
- Index(es):
Relevant Pages
|
