Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Has anybody ever written code using the ADO which fires several SQL
strings at SQL server and then copies and pastes each result into a different worksheet? I have to execute 15 queries - each takes 2 minutes. So if I can set them running at the same time things should only take 2 minutes whereas if I do one after another I'm looking at tying up Excel for 30 minutes ! Or does anybody understand my problem and know of a possible workaround. Any help much appreciated, Jason. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
queries with multiple criteria | Excel Discussion (Misc queries) | |||
Handling multiple SQL queries | Excel Programming | |||
Multiple queries under same connection | Excel Discussion (Misc queries) | |||
Multiple queries | Excel Programming | |||
Multiple Web Queries | Excel Programming |