How to connect to oracle tables (1 Viewer)

[marathonlady]

This is my first time using an access database to link to oracle tables. What's the verbage needed to connect to the tables?

Thanks

 

[jfgambit]

You can use the ODBC connections in Windows to connect to Oracle tables.

Check this article about Oracle ODBC Drivers for Windows:

http://support.microsoft.com/default.aspx?scid=kb;en-us;147192

And this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;208295

Also, when creating queries to ensure that you do not receive "time-out" errors when running against the Oracle tables make sure to change the ODBC Timeout Property in the Query from 60 to 0.

HTH

Jeff

 

[Pat Hartman]

From the Files menu, choose Get External data/ link. When the dialog box pops up, press the down arrow in the file type box and scroll down to ODBC. The next dialog will let you choose the ODBC data source you want to connect to or define a new one if you don't already have a pre-defined one. Once you connect to the desired Oracle db, you'll be presented with a list of tables to choose from. If you had to supply a password, you can have Access save the password in the table's connection string by checking the appropriate box.