From Excel run a Sql Script [message #260475] |
Mon, 20 August 2007 01:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
kumarvk
Messages: 214 Registered: July 2004
|
Senior Member |
|
|
Hi Experts,
Is there any way to run a sql script directly from excel and display the output directly into the worksheet?
Can anyone help?
|
|
|
|
|
|
Re: From Excel run a Sql Script [message #260489 is a reply to message #260484] |
Mon, 20 August 2007 02:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/43055.jpg) |
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
Michel Cadot wrote on Mon, 20 August 2007 09:24 | Does this work for a whole script?
| My bad. I didn't read the 'script' part the way you did.
I guess it all depends on what you call a script. If a script is a single SELECT statement: yes. If the script contains more SQL statements, you'd have to repeat the steps for each statement.
MHE
|
|
|