Conversion Settings

On this wizard screen you should select source MS Access database. Also, you can customize the conversion process using the following settings:

• Convert table definitions only - select this checkbox to convert only table definitions of the original MS Access database
• Skip converting indexes - select this checkbox if you don't want to convert indexes
• Make names uppercase - Oracle accepts lowercase names but you have to enclose them in quotes in queries. To avoid this problem you should select this checkbox.
  

Access-to-Oracle allows you to choose how to process MS Access tables that already exist in the destination Oracle database: overwrite, merge or skip converting existing tables.

• Select 'Overwrite' option to replace the contents of existing Oracle tables with MS Access data.
• Select 'Merge' option to merge MS Access data into the destination Oracle database. Access-to-Oracle implements quite simple merging algorithm. If a table has primary key or an unique index, the program inserts into Oracle database only those records whose key/index value does not exist in the destination Oracle table. Otherwise, Access-to-Oracle appends the whole table contents to the corresponding Oracle table. Note: the structures of source and destination tables must be identical.
• Select 'Skip' option to not convert existing tables.