Collections:
Connect MS Access to Oracle Servers in Oracle
How To Connect MS Access to Oracle Servers in Oracle?
✍: FYIcenter.com
Once you got a DSN defined in the ODBC manager that connects to an Oracle server, you can connect a normal MS Access document to the Oracle server, and link an Access table to Oracle table. The tutorial below gives you a good example:
You should see the Oracle ODBC Driver Connect dialog box as shown in the picture below:
Click the OK button to continue. You should see a list of tables available for you to import
from the Oracle server as shown in the picture below:
2016-10-15, 775👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Oracle Database 10g Express Edition? I want t...
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedu...