Connecting to External Database

[Guest]

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

 

[Fredrik Wahlgren]

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.aspx?scid=kb;en-us;278973

/Fredrik