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:
⇒ Connect ASP Pages to Oracle Servers in Oracle
⇐ Define DSN with ODBC Manager in Oracle
2016-10-15, 1574🔥, 0💬
Popular Posts:
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...