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?