I think that is it. Now I just need to figure out what the connection string to our Oracle apps database would be. I know in the poast, the string contained references to "uid" and "pwd" but I don't know the syntax.
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...
I am trying to create a make table query in Access that pulls data from an Oracle database table. The Oracle databse is listed in my TNSNAMES file. I'm looking for an example of a select or select into statement where the connection string to the database, username and password is included...