Access Link tables in Oracle

[ndisang]

hi all,
I have a requirement to move Access tables to Oracle. Honestly I have no clue where to start. I need some material for the process. Can anyone direct me where to find this process?
Thanks

[gandolf989]

Create an odbc connection to your Oracle database. Create the new tables on Oracle. Link the Access database to your new tables in Oracle. Create an insert query in Access to move the data over.

[ndisang]

Create an odbc connection to your Oracle database. Create the new tables on Oracle. Link the Access database to your new tables in Oracle. Create an insert query in Access to move the data over.

Thanks for the eye-opener. that's great for a start...
does anyone have a doc on this or a link to one?

[dbasan]

Use SQLLOADER, see on otn.oracle.com

http://www.princeton.edu/~storacle/sqlloader_demo.shtml

http://translate.google.com/translat...l%3Den%26lr%3D

Goodluck