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.