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, 1559🔥, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...