Unanswered: No tables in Existing Table list (ODBC link to Oracle from MS Access)
I have a problem with Win 2K / Access 2K. I use MS Access to manipulate data in an ORACLE dB (via ODBC). I have a WinNT box with MS Access 97 and often use the Import function to append data to one of the linked tables. I simply use the “Import Spreadsheet Wizard” and select the linked table from the “Existing Table” list.
I have not been able to make this work with Win2K and Access 2K as the “Existing Table” select list doesn’t show any of the linked tables. I have tried using several different versions of the ORACLE ODBC drivers with no luck.