Connecting to External Database

From within an Excel sheet I generate file containing SQL code , I want to
execute on an Oracle Database. In the current version of my program I use the
shell command to start an sqlplus.exe session. By attaching the connect
string and '@<File name>', the script is executed. I would like to eliminate
starting the sqlplus.exe and logging on to the database for every file I
generate by opening a session to the database only once and using this
connection to execute all the script files.

How can I achive this?

Thanks in advance Geert Engbers

"Geert" <[email protected]> wrote in message
news:[email protected]...
> From within an Excel sheet I generate file containing SQL code , I want to
> execute on an Oracle Database. In the current version of my program I use
the
> shell command to start an sqlplus.exe session. By attaching the connect
> string and '@<File name>', the script is executed. I would like to
eliminate
> starting the sqlplus.exe and logging on to the database for every file I
> generate by opening a session to the database only once and using this
> connection to execute all the script files.
>
> How can I achive this?
>
> Thanks in advance Geert Engbers

You may be able to call ADO from within VBA code. I suggest you google Excel
VBA ADO or excel macro ADO.
Here's a link that may help you to get started:
http://support.microsoft.com/default...b;en-us;278973

/Fredrik