View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geert Geert is offline
external usenet poster
 
Posts: 2
Default 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