Oracle provides a tool called Migration workbench which can migrate MS Access databases to Oracle. It works very well and allows you to control many facets of the migration. You can search for it on Oracle's Technet web site:
The documentation on 'Migration WorkBench' says it supports SQLServer 6.5, 7.0 and 2000, it also supports Sybase Adaptive Server 11 & 12. I did not see any reference to Microsoft Access !
Migration Workbench has MS Access translation plugins available on Oracle's technet website. You download and install the core product and then download the plugins for the data source types you need. You have to go through the download web pages before you get to the list of software to download. Also, you need to register as a technet user which is free. Hope this clarifies things.
If I'm not mistaken you want to move MS Access Data
into Oracle environment. I know that MS Access allows
such by FILE, Export function provided data is in
Access database. If you have not tried it then get back to me at Calvin.speights@brooks.af.mil.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.