Solved

connecting excel to oracle

Posted on 2011-09-22
2
185 Views
Last Modified: 2012-06-27
I have an excel spreadsheet that has a connection to an oracle database and I show some data in a table that based on a query on one of the oracle tables.

I want to send the spreadsheet to other users. Will I have to install the oracle drivers on every computer that will be using the spreadsheet?

thanks
alan
0
Comment
Question by:avoorheis
2 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 400 total points
Comment Utility
yes,  every machine will need some kind of client software installed
0
 
LVL 15

Assisted Solution

by:Devinder Singh Virdi
Devinder Singh Virdi earned 100 total points
Comment Utility
>>I want to send the spreadsheet to other users
I believe, if you save the result in spread sheet, then you dont need to install oracle in client side, but if they want to execute the query, then they need.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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 …

763 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now