Solved

connecting excel to oracle

Posted on 2011-09-22
2
187 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
ID: 36581687
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
ID: 36583478
>>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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

911 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

20 Experts available now in Live!

Get 1:1 Help Now