Migrating From Access to Oracle

[greenMark]

Can anybody let me know how to migrate data from MS Acess to Oracle. I tried with a PL/SQL procedure. But it didn't work. Are there any in-built functions within Access? Thank you

[amitpatel66]

Can anybody let me know how to migrate data from MS Acess to Oracle. I tried with a PL/SQL procedure. But it didn't work. Are there any in-built functions within Access? Thank you

Try exporting the data from MS ACCESS to any flat file either txt or csv and then use SQL LOADER to upload the data in to oracle database

[mygr8r]

I have rarely found any data migration that is so simple that you can export from one database and import or load the data as-is into another database. If your migration is that easy, count your blessings and go for it!

If, however, you need to do any data mapping and/or manipulation, you should take a look at the Data UpLoader to Oracle on this web site:
http://pervasivedatatools.com/datatools

That data tool can read data directly from MS Access (and many other databases) and lets you map the data to Oracle. I've used several of these data tools and usually find them very helpful.

Hope this helps!
-mygr8r

[bxchen]

I used DFSTrans to migrate Access to Oracle, it gives you all the flexibilities for data manipulation, and many to many mapping, very easy to use. Here is the web site: www.directfocussoftware.com.

Hope this help.

Sam