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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle and Access

Re: Oracle and Access

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Tue, 26 Jun 2001 10:40:15 -0700
Message-ID: <3B38C8FF.C5D534A3@attws.com>

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

Original text of this message

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