Oracle ODBC connectivity - How to attach an Oracle table in MS-Access? posted
by Babu Kunwar
How to attach an Oracle table in MS-Access?
Microsoft Access is part of the Office 2000 suite and has a strong ability to
“link” to tables in other databases including Oracle. The connection is done
through the use of a standard called Open Database Connectivity (ODBC).The
steps defined below explains to attach Oracle table in MS-Access:
Steps:
Once the PC has been set up to access Oracle data sources, we can link to any
table within an Oracle server. Start up Access and create or open a database
file.
To link to Oracle tables:
-
Start the linking process by either selecting File. > Get External Data
-> LinkTables or right click within the Tables list and select Link Tables
from the popup menu.
-
Select the ODBC Databases in the Files of type drop down list at the bottom of
the screen. This will tell Access that we want to link to an ODBC data source
and will pop up the Select Data Source dialog box.
-
Select the Machine Data Source tab and select the appropriate Data Source Name
in the list and click Ok. This will open up a login dialog box.
-
Once we login successfully onto Oracle, a list of tables and views will pop up
in a dialog box.
-
Now you are able to use these tables or views in the same way as the as it was
in MS-ACCESS.
More links
What is an Index? Explain how to create an Index.
What is Function-Based Index? Create a Function-Based Index.........
|
