Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically connecting to a remote database | Excel Discussion (Misc queries) | |||
External Database Source | Excel Worksheet Functions | |||
Links to External Database | Excel Discussion (Misc queries) | |||
DSUM with External Database | Excel Worksheet Functions | |||
Excel Connecting to SQL Server Database - Need your Help | Excel Programming |