Re: Newbie : Oracle data to Access table.

"General Fear" <richmarin@xxxxxxxxxxxxx> wrote in message
news:1138059150.326811.149340@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> I am using VB 6.0 and Access 2002.
>
> I have a task where I need to do a select statement against an Oracle
> table and put the data into an Access table. The SQL might look like :
>
> " Insert Into MyAccessTable Select * From OracleTable "
>
> Can I do this using ADO. If so, how ???
>
> ..
>

There are at least a couple of different ways to do this, here is one;

You could create a database link to the Oracle server and issue the above
insert statement.

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


.

Relevant Pages