=SQL.REQUEST()

[rjre]

There used to be a function (in Excel 2002 with an addin) called
=SQL.REQUEST().

i believe this no longers exists in Excel 2003(!). Does anyone know of
an equivalent function or is it always the VBA route?

thanks

richard

 

[Héctor Miguel]

hi, !

There used to be a function (in Excel 2002 with an addin) called =SQL.REQUEST().
i believe this no longers exists in Excel 2003(!).
Does anyone know of an equivalent function or is it always the VBA route?

AFAIK, the add-in you recall is "xlodbc.xla" distributed in versions 5, 95, 97 and 2000
(2002 ane beyond no more includes this -and ohers- add-ins), see:

Add-ins that are not included with Excel
http://support.microsoft.com/kb/288118
(from here you can download this add-in and others too)

additional information:
SQLRequest Function
http://msdn.microsoft.com/en-us/library/bb257085.aspx

hth,
hector.