Re: Migrate Data from MSAccess to Oracle

Praveen wrote:

> Hi All,
>
> We have an application in french language at client site which is
> using MS-Access as DB. Now we redesigned the application to web based
> using java and Oracle as the backend DB. Now they want to load data in
> MS-Access db to oracle db. I'm using UTF8 db in oracle. Oracle DB and
> MSAccess DB are not much syncronized with tables/columns. Can anyone
> tell me how can i approach for data migration?
>
> Thanks in advance,
> Praveen

1. Dump the data to delimited ASCII files
2. Use SQL*Loader

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)