Excel 2003 SP2, xlodbc.xla installed. use sqlrequest connect to ms sql
7.0
In one excel cell, I put bellow formula:
=SQLREQUEST(quot;DSN=sql-sg;UID=scala;PWD=scala;Database=scalaDBquot;,
quot;select SC11003, SC11007, SC11004, SC11005, SC11015 from SC115300 where
SC11001 = '33552000' order by SC11001quot;,,2,FALSE)
If I run above sql query from SQL Query Analysis, it returns:
0053900060Water Technology AG amp; CO KG76-768.01
0000001997 761728.0A
0053900061Water Technology AG amp; CO KG76-1920.01
0000001998 761920.0A
0000002010 762400.0A
0053900041Water Technology AG amp; CO KG76-2400.01
0053900062Water Technology AG amp; CO KG76-1920.01
But in excel only return 0053900060. it looks like Excel can't display
whole recordsets.
Any clue?
thanks in advance
Xu Zuoyin
- Feb 22 Thu 2007 20:36
Sqlrequest only return one value
close
全站熱搜
留言列表
發表留言