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