As you have found out, this add-in is no longer included with Microsoft
Excel. You can get it from Microsoft by following this link -
http://office.microsoft.com/downloads/2002/xlodbc.aspx
This is where Uncle Bill isn't being too helpful :-(
Here's how to get the files::
Open the xlodbc.exe using, say, Winzip.
Copy the files to a convenient location.
From within Excel, browse to the add-in file and load it as normal
--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
"M.Heer" wrote in message
...
I have found that the SQL.REQUEST function is not an option in Excel 2003
any
longer. Is there another function that will access data stored in an SQL
server?
"Harlan Grove" wrote:
"M.Heer" wrote...
I understand that. The problem is that in order to have the SQL.REQUEST
function work you need to have Excel ODBC installed and I can't find
where to get that for Excel 2003 version. On the microsoft website they
do have the download available, but it is for Excel 2002 and XP
versions-- will not work on Excel 2003 version. . . .
And are you *CERTAIN* of that last statement?!
In fact, it's PRECISELY the 2002/XP version you need since it hasn't
changed
since Excel 95. [Look under the hood - it's XLM code calling an external
DLL
that still carries the Excel 5.0 version label.]
The only mystery here is why, in its infinite wisdom, Microsoft chose to
drop the ODBC add-in from the Office product CD.