MS Access to Oracle 8i

[santoshym]

Hi Everybody,

I want to move the data from MS Access to Oracle 8i database How do I do this If anybody has done can they put the steps with a small example

It is allmost like a small migration from MS Access to Oracle 8i

Thanks

[marist89]

If its a small database (# of tables) then this is what I would do:
1. create your tables on the oracle side
2. attach the oracle tables to the access .mdb via ODBC
3. create an append query for each of the access tables to append data to the oracle table

Hint: You can use the "Save As" feature of access to save your table into Oracle via ODBC. However, I don't recommend it because the table and field names get saved in mixed case in oracle and it's a real pain to deal with. If you have more questions, cc my email addres ( I don't visit this forum as often)

[santoshym]

Hi Jeff

Thanks a lot for the steps I will try those steps If I have a problem surely I will mail you.

Thanks

Santosh