Excel open oracle connection

[gwoman]

I haven't worked with Excel very much .... and I have inherited an Excel workbook that collects and displays data form an Oracle database (several different tables) using Microsoft query. Currently this process takes an extremely long time because it has to go through a list of items (approx 200) and the way it’s set up it creates a new connection for every item in the list. Is it possible in Excel to create one connection and leave it open while it cursors through the list of items .... therefore creating only one connection instead of 200+?

Thanks much ...

gwoman

 

[SkipVought]

Hi,

Yes, it is possible, but not with native Excel built-in features. You will need to modify some VBA, from what I percieve from your question.

Please repost in Forum707.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[gwoman]

Will do ... thanks!