Re: MS Access and Oracle
Date: Tue, 26 Jun 2001 10:33:24 -0700
Message-ID: <9haguu$ls9$1_at_news.orst.edu>
Write the data from Access to a file, then ftp it to the host computer and use SQL*Loader to insert the rows.
Brad Dennis
"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:33:24 CEST