Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    370

    Question Unanswered: Import data from MS Access into Oracle 9i

    Hi all,
    We have some old data in a project that are in Access and want to move them to Oracle 9i(version 2) but I didnt know what should I do...Finally I move them into SQL server 2000 using its import/export wizard and then try to move the result into Oracle but It failed without any reason or in some few tables takes alot.
    Can you help me if there is a better way please?
    thanx in advance...

  2. #2
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102
    maybe the Oracle Migration Workbench
    http://otn.oracle.com/tech/migration...as/access.html
    might help.
    ^/\x

  3. #3
    Join Date
    Apr 2004
    Posts
    246
    why not just an ODBC connection from Access to Oracle, and save the data directly.
    Give a man a fish, you feed him for a day. Club him over the head with a fish, he'll leave you alone.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •