Discussions
Categories
- 382.6K All Categories
- 2.1K Data
- 213 Big Data Appliance
- 1.9K Data Science
- 448.5K Databases
- 221.1K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 541 MySQL Community Space
- 469 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 500 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.3K SQL & PL/SQL
- 21.1K SQL Developer
- 293.9K Development
- 9 Developer Projects
- 130 Programming Languages
- 290.6K Development Tools
- 97 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 151 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 146 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 201 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 298 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 168 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 234 Portuguese
How do I connect to an Oracle 10g database using MS Access 2010?
I'm using Windows7, Office 2010 32-Bit, MS Access 2010, and Oracle 10g
I'm trying to connect to an Oracle 10g database via Microsoft Access. Can someone provide a link to where I can get the drivers? I found this on the Oracle site,
"Oracle 10g Release 2 ODAC and Oracle Developer Tools for Visual Studio .NET"
but I'm not doing any Visual Studio development, I just want to view the table structure in the Oracle database via a connection provider using MS Access 2010. Any help would be greatly appreciated. Thank You.
Answers
-
https://www.google.com/search?q=connect+to+an+Oracle+10g+database+via+Microsoft+Access
BTW - V10 Oracle is obsoleted & unsupported
You need to install Oracle client software, & then configure ODBC to use it.
-
This document is a bit dated but it shows the steps. Connecting with Oracle: Accessing Oracle via Access and Excel — DatabaseJournal.com
Basically, you need to install Oracle Client with the ODBC drivers. Create an ODBC DSN pointing to your Oracle database. Then link tables in Access over the ODBC connection.
Cheers,
Brian -
Thanks for the information. I'll check with our IT folks to verify what version of Oracle we're using.
-
To connect from MS-ACCESS to Oracle database, you can link table feature in MS-ACCESS which will connect to Oracle database via ODBC. This doesn't require Visual Studio.
All you need is Oracle Instant Client and Oracle ODBC driver. You can download those in following link: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
-
One more point to consider! If your MS Access is 32bit you need to download 32bit Instant Client basic and Oracle ODBC driver package. Use 64bit Oracle Instant client and ODBC driver for 64bit MS Access.
Instant Client downloads for Microsoft Windows (x64) - 64 bit
Instant Client downloads for Windows - 32 bit
-
Hi Brian,
You can use Oracle ODBC driver 32 bit to connect Oracle database from MS Access. Refer the below document to for steps:
How to Install/Configure ODBC Driver On Windows 64bit With MS Office Products Like Excel, Access or Word - Release 11.2.0.4 (Doc ID 1617349.1)
thanks and regards
Venkat