Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle and Access
vidas wrote:
> 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
Dump the data from Access as a vertical bar delimited file and use SQL Loader to put it into Oracle.
Daniel A. Morgan Received on Tue Jun 26 2001 - 12:40:15 CDT