Unanswered: ODBC Link Tables not full list of tables
Wondering if you can help with a problem with topic Linking to a table from Access to another database via ODBC.
I have been able to create a successful ODBC driver link from Access DB to an Oracle 9.x DB using Access > Get External Data > Link Tables.
However, the list of tables returned is not the full list (table list gets truncated) and unfortunately, the tables I need to join to do not show on the list (would be further down than the bottom of the list).
Do you have any ideas how I can still link tables via ODBC when tables do not appear in the list?? Is there anyway to point to a specific table when connecting, excluding all others??