MS Access to Oracle 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: MS Access to Oracle 8i

  1. #1
    Join Date
    Mar 2001
    Posts
    635
    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Mar 2001
    Posts
    635
    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
  •  



Click Here to Expand Forum to Full Width