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, 3550🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Connect to a MySQL Server with a Port Number in MySQL? If you want to connect a MySQL server ...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...