Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: import from ms-access to oracle 8i

    hi,
    I would like to import data from ms-access tables to oracle8i thru a stored procedure. can someone pl. help me with this.
    TIA.

    Regards,
    Ashish

  2. #2
    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    1

    Re: import from ms-access to oracle 8i

    I have done many upload of information from Access to Oracle NOT with a pl/sql stored procedure.

    Solution 1:
    Simply configure an ODBC connection to your Oracle DB.
    Open you Access database and create linked tables (only the one you want to populate)
    Write some sql (insert/update) statement against these linked tables.

    Then your data will be on you Oracle DB.

    Solution 2: (should be easy to build, but I have never done it)

    Write a java stored procedure that will connect to your Access db and your Oracle database using the the jdbcdbc bridge, then publish it in pl/sql and the trick will be done as well...

    Cheers,

    Philippe

Posting Permissions

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