RE: Migrating from MS Access to oracle

> From: Pardee, Roy E [mailto:roy.e.pardee_at_lmco.com]
>
>
> I've never used it, but oracle has a Migration Workbench
> product that is supposed to do such things. See
>
> <http://otn.oracle.com/tech/migration/focusareas/access.html>
>

I used it once a few versions ago; ran into issues with regards case-sensitive tables and other drek.

I decided to just extract the table data from access and insert into Oracle via SQL*Loader, and was happy to do it. Then a bit ago I tried using the migration tool again with 9.2, and discovered it much easier and effective. I'd suggest giving it a try before diving into SQL*Loader ;-)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremy Pulcifer
  INET: Jeremy.Pulcifer_at_kadiri.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).