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

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 Fri Feb 18 2000 - 22:27:44 CST