We have several Access databases and we need to copy the tables over to Oracle. What would be the best way to copy these tables over? I need the table names, fields, data type and data intact once it moves. Another word, a mirror image of tables in access in oracle.
Thanks In advance
connect to oracle db via odbc (login / password)
connect to Access DB and read each table
copy table to Oracle
loop through until all tables are coped to Oracle
close connection 1
close connection 2