Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: Using a system DSN

    I have created a system DSN to enable me import data from an oracle table into Access. I have used the Oracle Driver and the Microsoft ODBC drivers and they both give me the connections.

    However, when i come to the dialog box to select the table name, I do not find it there. Rather i find a list of Oracle system tables and not mine. I tried to import just any table and it worked showing me that my DSN really works.

    Does anyone know how to get the actual table name i want to be displayed? and thus enable me import or link it?

  2. #2
    Join Date
    Sep 2003
    Are you connecting using the same username that you used to create the tables? If not you may need to create a synonym for the target table in the schema of the user you wish to connect as.

Posting Permissions

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