Re: MS Access and Oracle
Date: Tue, 26 Jun 2001 17:32:30 GMT
Message-ID: <NG3_6.1911$aX5.231192_at_paloalto-snr1.gtei.net>
What do you mean "best solution"?
To my thinking, the simplest solution would be to Link the Oracle Table(S), create an Append Query, and run it. As you already have Access clients Linked to Oracle, I assume doing so would be no problem. If you are going to do this transfer once, or infrequently, then the speed is not a matter of great consequence.
On the other hand, if you have lots of records, need to do the transfer frequently, and can get an ADO data provider for your version of Oracle, then using VBA with ADO will likely require a learning curve, but will, in the end be somewhat faster, because it bypasses Jet. I cannot imagine this being worthwhile, however, for a one-time or infrequent need to transfer.
"vidas" <vidasm_at_yahoo.com> wrote in message
news:cdbd2dd.0106260806.468d3b95_at_posting.google.com...
> Hi,
>
> I have two databases - Oracle and MS Access. To perform a task I need
> to move around 100'000 lines from Access to Oracle over the network or
> vice versa.
>
> Linking tables in Access seems to be not the best solution - those
> tables are already linked (are being updated) from other Access
> databases (one access mdb acts like a major database, other mdbs - as
> clients).
> Via ODBS this process tends to be very slow.
>
> Some suggestions?
>
> thanks,
> vidas
Received on Tue Jun 26 2001 - 19:32:30 CEST