Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have an interactive report which uses a combination of SQL statements, VB and other excel functions to return various stats driven by what the user sets as perameters. The SQL statements are stored in excel on a worksheet and i have written an ADO connection module to create a connection to the database and execute the SQL. The results are then returned into the same excel workbook. The SQL works and all results are returned however it seems a little slow. I have tried running the SQL in access itself and the total duration of the 4 queries is approx 1minute but running through excel, the SQL execution time is 3minutes. Does anybody have any idea why executing SQL through excel would take almost triple the time than directly in access? Please could somebody advise how i can get round this and speed the SQL execution up? All help greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 07 running slow | New Users to Excel | |||
Excel performance running slow | Excel Discussion (Misc queries) | |||
excel running slow when saving | Excel Discussion (Misc queries) | |||
excel macros running slow with XP | Excel Programming | |||
Excel running really slow on my machine | Excel Programming |