This is a tool that helps automatic migration of existing databases in Access to tables in Oracle.

AccessToOracle is a data conversion tool that helps DBA and database programmer convert Access data to Oracle database. You can set up the migration automatically through a visual interface. Once set up, it is a one click action. The progress bar gives you an estimate of how much time is left to finish the process. Command line and scheduled operations let you complete the process unattended. The configuration settings are easy through this simple interface. You need to select the source table of course. You then select a destination schema. You could select/deselect fields too. The configuration details could be saved and reused again and again in similar situations. Preview lets you make sure that everything is alright before you start the conversion.

The conversion can be applied to not only table to table but also query to tables. Access database is quite a popular database used in the SME segment. However the problem is once your business grows beyond a particular size, it is necessary to change over to a regular database product like the Oracle, for example. Oracle is one of the most popular and generally considered a robust database for enterprise use. If you are going to do this switch over some time through your business life, you would have accumulated a large amount of data that needs to be migrated. The problem at the switch over time is that this can be a voluminous job. Automatic tools like these are very handy at such times. If you have a impending switch over, you should try this out.