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

    Unhappy 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.

    Any suggestions?


  2. #2
    Join Date
    Apr 2003
    Greenville, SC (USA)
    I had similar problems until I upgraded to Oracle Odbc driver.

Posting Permissions

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