Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: load data
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. Received on Mon Aug 28 2006 - 10:52:16 CDT
![]() |
![]() |