Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks - never used it. Recent MS updates have raised some issues with
OLEDB. We use ADO exclusively now...which my code also uses. We found that an update about 2 weeks ago caused our pivot tables ( default to OLEDB) were taking up to 45 minutes to refresh 300,000 rows from our databases. Setting the pivot cash instead to an ADODB recordset got us back to <2 minutes. -- Patrick Molloy Microsoft Excel MVP --------------------------------- "Andy Wiggins" wrote in message ... Upto and including Excel 2002 SQL.REQUEST has been part of the XLODBC addin supplied by Uncle Bill. -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA" "Patrick Molloy" wrote in message ... This is not a standard Excel function - it looks like sombody made one for you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If then request | Excel Worksheet Functions | |||
Request | Excel Discussion (Misc queries) | |||
sql.request | Excel Discussion (Misc queries) | |||
sql.request | Excel Worksheet Functions | |||
Add-on to last request | Excel Programming |