1 Reply Latest reply: Nov 11, 2011 12:41 AM by Kgronau-Oracle RSS

    Linking Access tables, creating a query with using both Access and Oracle

    874760
      Hello,


      I am using 3.0.04.34 version Oracle Developer. I am supposed to create a script/procedure to use both Access tables and oracle tables together. There is an option in developer to copy the access tables into oracle. But it doesn't help me. Because when we updated the access tables
      the copied ones are not be updated. How can I created a linked access tables to oracle and create a query with using both access and oracle table together.

      I will appreciate if you guys help me. I look forward to hearing from you guys.

      Thanks,
      Pinar
        • 1. Re: Linking Access tables, creating a query with using both Access and Oracle
          Kgronau-Oracle
          Pinar,
          to be able to query MS Access tables in Oracle you need an additional product, the Oracle Database Gateway for ODBC. It allows you to link any foreign database into an Oracle database using a suitable ODBC driver. You can then access the MS Access tables through a database link based on the Database Gateway for ODBC. This will also allow you to join local Oracle and remote MS Access tables from your Oracle database.

          There's a note on My Oracle Support which gives you more details:Document 233876.1 Options for Connecting to Foreign Data Stores and Non-Oracle Databases - For example - DB2, SQL*Server, Sybase, Informix, Teradata, MySQL

          And there's also a dedicated Forum: Heterogeneous Connectivity