Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Inserting into Access table from ADO Rset or Cmd from Oracle

Inserting into Access table from ADO Rset or Cmd from Oracle

From: jason <jfielding_at_trinitech.co.uk>
Date: Fri, 18 Feb 2000 15:05:03 -0000
Message-ID: <88jn31$ilq$1@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 - 09:05:03 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US