This content has been marked as final. Show 2 replies
If you are using windows, under the Tools > Migration Menu, you should get a set of Access Exporters which you can run against your database. This will generate an xml file which you can load with the wizard to see the structure of the Access database.
If it is just data you need, then you can make an access connection and right click on the table in the access connection and select "Copy to Oracle". This will copy the tables and data to oracle.
I am not using "Copy to Oracle" option since it don't copies everything (constraint, relationships, complete data etc) to oracle (as per oracle documentation). Also I am getting error while using Access exporter (Error # 3270) from Tools>Migration>MS Access Exporter.
Does the Tools>Migration>Migrate option is not meant for MS Access migration?