calls to extract data from an open database
I have a workbook that on the €śopen€ť event connects to an Oracle database
using ADO, this works fine.
I need to code various calls to the data base to run several queries. How
do I achieve this? Do I have to repeat the ADO connection string to the
database complete with password etc; I am sure this is not necessary.
Any code will be very gratefully received.
--
with kind regards
Spike
|