How do I access Oracle from Excel on a MAC?

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,
Christopher ScheneSystem Engineer/Software EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ugo MenaCommented:
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
Christopher ScheneSystem Engineer/Software EngineerAuthor Commented:
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
Ugo MenaCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Christopher ScheneSystem Engineer/Software EngineerAuthor Commented:
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
jtriftsMI and AutomationCommented:
0
Ugo MenaCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Christopher ScheneSystem Engineer/Software EngineerAuthor Commented:
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
Christopher ScheneSystem Engineer/Software EngineerAuthor Commented:
Works great!  Thanks,
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.