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

Connecting to External Database
 

"Geert" wrote in message
...
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