Excel 2002 Add-in: Open Database Connectivity available for Excel

[Guest]

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?

 

[Jim Rech]

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
| 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?

 

[Guest]

Thanks!

 

[Guest]

I downloaded XLODBC and installed it on Excel 2003. But how do you use it?
Is it a function?

 

[Guest]

I should have added that Harlan Grove gave me the following website where I
found XLODBD and downloaded it.

http://www.microsoft.com/downloads/...67-13A0-4895-9942-5B177846AB8A&displaylang=en

 

[Myrna Larson]

The information on the web site from which you downloaded it says that it
contains the SQL.REQUEST function. Presumably, after you've installed the
add-in, you can get help on that function.

 

[Giuseppe]

Simple try as follow:

(1) Download from microsoft update the Archive XLODBC.EXE
(2) Extract it to a folder (Among the files there should be one named
XLODBC.XLA)
(3) Open Excel 2003, go to Tool->Add-in and click to search
(4) Find XLODBC.XLA
(5) Over

123user ha scritto:

 

[Guest]

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