SQL.REQUEST on SQL Server

F

Flemming

Hi

I have a very simple question. I have a sql server 2000
and are running office 2002 on my XP client. In excel i
am trying to retrieve data from a table in the sql
server, but are unable to get excel to find the data.

I have tried several other ways to retrieve data from the
server eg. a reporting tool (Crystal), ms QUERY etc.
which all work fine, however sql.request does not (the
add-in IS installed)

I have this formula:

='C:\Program Files\Microsoft Office\Office10
\LIBRARY\MSQUERY\XLODBC.XLA'!sql.request
("dsn=capa;uid=POKB;pwd=kb06"; A1; 2; "Select count(*)
from KBLink"; TRUE)

The result is

#REF in the A1 cell.

I have tried this several times from an oracle server and
everything works fine, why will this not work on the sql
server ??

Regards
Flemming
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top