View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_4_] Patrick Molloy[_4_] is offline
external usenet poster
 
Posts: 103
Default SQL.REQUEST #N/A error

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.