close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()