-
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
Santosh
-
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)
Jeff Hunter
-
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
Santosh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|