I've tried editing the registry (installation completed successfully) but
when I enter the SQL.REQUEST function in a cell in an excel worksheet,
nothing happens; no processing. It's as though I've entered text. Does any
know the EXACT syntax for this command for the connection string, query_text,
etc.? Thanks

"Jim Rech" wrote:

It doesn't look as if MS released a version that installs with Excel 2003.

If you are comfortable with the registry editor (RegEdit.exe from
Start-Run) you can easily fool the installer to think you have Excel 2002
installed.

First create the path:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\10.0\ Common\InstallRoot

Then create a new String entry under InstallRoot named Path. The value of
Path should be the path to your Office 2003 installation, e.g. C:\Microsoft
Office\Office11\

--
Jim
"Nick B" wrote in message
...
| Does anyone know if you can get the Excel Open Database Connectivity for
| Excel 2003? We are trying to use the sql.request function in Excel 2003
and
| it is not installed (returns #NAME?). In the Excel help it says "If this
| function is not available, you must install the Microsoft Excel ODBC
add-in
| program (XLODBC.XLA). You can install the add-in from the Microsoft Office
| Web site.". I went online and found it for Excel 2002, which I promptly
| downloaded and tried to install and it installed on one computer (not a
clean
| machine - has Office 2000 and 2003 (but it does have Project 2002, but not
| Office 2002), but it will not install on the other machines saying
"Microsoft
| Office XP or Excel 2002 not found." Am I missing it online?