Re: Inserting into Access table from ADO Rset or Cmd from Oracle

An even easier way is to make a create table query in Access and just execute it from VB. You will have to link the view to the Access database for this to work I think. When you are done with the new table drop it so you don't get an error the next time the create table query is run.

Derek.

In article <88qvqs$4qh$1_at_trinitech.demon.co.uk>, "jason" <jfielding_at_trinitech.co.uk> wrote:

> I've never used Macros, would I be able to execute the macro from VB at
> run-time ?; and, can this be done without linking the Oracle View into
> Access ?
> Jason
>
> Rob DeMarco wrote in message
> <4Zor4.17935$Zp1.587212_at_newsread1.prod.itd.earthlink.net>...
> >Jason,
> >
> >Skip the middle man. Set up an Access 97 macro that
> >will import the view's records from an ODBC
> >data source (namely your oracle db) into a blank table.
> >You will be hard pressed to find a way to use ADO for such a bulk
> operation.
> >
> >Rob
> >
> >jason <jfielding_at_trinitech.co.uk> wrote in message
> >news:88jn31$ilq$1_at_trinitech.demon.co.uk...
> >> Hi,
> >> I'm using VB6, Access 97 and Oralce 8.04.
> >> Can anyone tell me 1) If it's possible .... and 2) a hint on how .....
> >> .......to retrieve data from an Oracle View using either an ADO
> >> Recordset or ADO Command (can do that bit) - but then insert
> >> this data straight into an empty Access table - without looping
> >> through the retrieved data record by record ?
> >>
> >> Any pointers would be really appreciated.
> >> TIA
> >> Jason
> >>
> >>
> >
> >
Received on Mon Feb 21 2000 - 17:44:32 CST