MS Access to Oracle converter merges data according to the following algorithm. If a table has primary key or an unique index, the program inserts into MS SQL database only those records whose key/index value does not exist in the destination table. Otherwise, the application appends the whole table contents to the corresponding Oracle table.
Note: the structures of MS Access and Oracle tables must be identical.
Have questions? Contact us