Solved

execute Oracle function in Excel 2010 using ODBC

Posted on 2013-01-14
2
693 Views
Last Modified: 2013-01-22
Hi Experts,

I would like to execute an Oracle sql in Excel 2010 using ODBC.  Connection to the database works but I am not sure how to run the script.

Example script:
===========
SELECT 
'This is a test', Name
api.functioncall('&val1','&val2','&val3') value1,
api.functioncall2('&val1','&val2','&val3') value2,
(select somevalue from someview where field1 = '&val1' and field2 = '&val2' and field3 = '&val3') value3
FROM DUAL

Open in new window

===============

The results should then populate the worksheet.

Thanks in advance.
0
Comment
Question by:taylort2
2 Comments
 
LVL 19

Accepted Solution

by:
Thommy earned 250 total points
ID: 38776162
You can use Data Connection Wizard...
Query Oracle database

or execute a query
Execute Oracle Query (DML) from Exc
0
 
LVL 23

Assisted Solution

by:paquicuba
paquicuba earned 250 total points
ID: 38776324
Follow this instructions and it'll work for sure:

http://blog.mclaughlinsoftware.com/2009/11/30/sql-query-in-excel-2007/

Let me know if you need more help...I've done it before and it works
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Query Missing Money orders... 6 67
PAYER_ID has both atributes 4 19
VLOOKUP Function MS Excel 2010 2 20
Gantt chart 2 12
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

707 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

14 Experts available now in Live!

Get 1:1 Help Now