Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2004
    Posts
    4

    Wink Unanswered: Link access tables to oracle

    How do I link and popluate my access tables to an oracle database?

    I'm using Oracle 8i.

    Thanks.
    Last edited by tware; 08-10-04 at 16:49.

  2. #2
    Join Date
    Jan 2004
    Location
    Scottsdale, AZ
    Posts
    106

    Post

    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Setup an ODBC connection using the Oracle ODBC drivers...

    If you don't have at least the 8.1.7.4 ODBC drivers from Oracle, DOWNLOAD
    them !!!! There were problems with the original 8.1.7 drivers off the CD ...
    Pick up the patch from the OTN website and run the Oracle installer to install them ...

    HTH
    Gregg

  4. #4
    Join Date
    Jun 2003
    Location
    Ottawa
    Posts
    105

    ETL tool

    There are lots of nice and easy etl tools you could use too.. (if you have the $)

    Cognos DecisionStream
    BO - Data Integrator
    Informatica....to name a few.

    DTS in SQL Server is not too bad too.

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I never tried it, but commercial says it is a "bridge between Excel and all your databases" - www.oraxcel.com. So, perhaps it is easy to populate Excel spreadsheet from an Access table, and then import Excel into Oracle.

    Don't like it at all, to be honest. I prefer Gregg's suggestion.

    P.S. Found this thread on the Forum ...
    Last edited by Littlefoot; 08-11-04 at 08:48.

  6. #6
    Join Date
    Nov 2003
    Location
    Bangalore,India
    Posts
    51
    right click on the tables in access and say link tables
    choose odbc database
    Cheers

Posting Permissions

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