Linking to Oracle Tables

[feltondude]

I'm trying to establish links to tables within an Oracle database. When I use the standard import objects pointing to the ODBC database, it produces a list of tables that only shows the first approx 100 tables in the Oracle instance. There is no way for me to scroll further down the list to pick a table name starting with "M" for instance. Is there anyway for me to explicitly define the table name I want to import so I don't run into the UI limitations of the import wizard?

 

[Banana]

How curious. I'd expect the UI to allow you to browse more than that.

Is this true regardless of drivers you're using?

But to answer your question- you can link tables via code.

Google Carl Prothman's connection strings site to get your connection string then use that snippet (aircode!):

Dim tdf As DAO.TableDef

Set tdf = CurrentDb.CreateTableDef("MyLinkedTable", dbAttachedODBC, "NameOfTableAsNamedOnOracle", "ConnectionString")
CurrentDb.TableDefs.Append tdf