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 - 03:17:23 CST
