Re: load data

From: Vince <vinnyop_at_yahoo.com>
Date: 29 Aug 2006 15:58:22 -0700
Message-ID: <1156892302.815710.179040@i3g2000cwc.googlegroups.com>

Bob Jones wrote:
> "Vince" <vinnyop_at_yahoo.com> wrote in message
> news:1156780336.488936.101710_at_b28g2000cwb.googlegroups.com...
> >
> > Bob Jones wrote:
> >> <soalvajavab1_at_yahoo.com> wrote in message
> >> news:1156518262.158259.58550_at_h48g2000cwc.googlegroups.com...
> >> >_ what is the best approach to load MS Access data to Oracle table?
> >> >
> >>
> >> Create a link from Access and then insert into Oracle tables.
> >
> > This approach works reasonably well for smaller amounts of data. The
> > export then load via SQL*Loader is much faster.
> >

> How big can Access tables be? By the time you finish writing export and load
> scripts, I am already done with the inserts.

Access 2000 and later, tables can be as big as 2gb. Access97 has a 1gb limit. Received on Tue Aug 29 2006 - 17:58:22 CDT