Solved

How do I access Oracle from Excel on a MAC?

Posted on 2014-09-05
8
518 Views
Last Modified: 2014-09-09
I need to access Oracle from excel on a MAC.

I would also like the same access to work on my PC.

Example queries would be much appreciated.

Thanks,
0
Comment
Question by:Christopher Schene
  • 4
  • 3
8 Comments
 
LVL 13

Expert Comment

by:Ugo Mena
ID: 40306642
Excel requires ODBC drivers to connect to an Oracle database. See http://www.actualtech.com/product_oracle.php for more info on Mac version.
Also here for both Mac and PC drivers : http://uda.openlinksw.com/odbc-oracle-ee/

Otherwise, you can also use a database tool like DBVisualizer (one of my favorite free DB tools) http://www.dbvis.com/download/
to directly connect to your DB and run queries.

There are versions for each OS (Windows, Mac, Linux, UNIX) and both a FREE and PRO version depending on the tasks you need to perform on your database.

Oracle       8i, 9i, 10g, 11g, 12c are supported.

You can find examples, online demos and a very thorough User and Support forum.
0
 

Author Comment

by:Christopher Schene
ID: 40306719
I actually need to use excel for standardization purposes, though I suppose I could use open office to create an excel file if OO could access Oracle.

No free solutions for the Oracle driver? Since my company has a licensed version of excel I guessed the Microsoft might have an Oracle  ODBC driver.
0
 
LVL 13

Expert Comment

by:Ugo Mena
ID: 40306748
Microsoft no longer makes an ODBC driver for Oracle and instead recommends using Oracle's ODBC driver
http://msdn.microsoft.com/en-us/library/ms713590%28v=vs.85%29.aspx

Oracle Free download of ODBC drivers page:
http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-098155.html
0
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 

Author Comment

by:Christopher Schene
ID: 40310404
I could not find a driver for the version of Oracle we are using (12).

Maybe a better approach is to write the DB interface in Java and just call the java program from excel?

What do you think?
0
 
LVL 4

Expert Comment

by:jtrifts
ID: 40311981
0
 
LVL 13

Accepted Solution

by:
Ugo Mena earned 500 total points
ID: 40312493
The above still indicates how to connect Oracle 11g database from Excel 2007...

Yes, you could try using Java's JDBC from within Excel.

This may be just what your looking for : Java Program to connect Oracle Database with Example - JDBC Tutorial Sample Code   http://javarevisited.blogspot.sg/2012/04/java-program-to-connect-oracle-database.html
0
 

Author Comment

by:Christopher Schene
ID: 40313536
ultralites : I tried your solution and I got an error " throw new SQLException("No suitable driver found for "+ url, "08001");"

What puzzles me is that I have SQl Developer installed and that works: How does it get to the database?

I can't find an up to date Oracle driver that works on mac.

Thanks,
0
 

Author Closing Comment

by:Christopher Schene
ID: 40313566
Works great!  Thanks,
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question