A
AY Xu
Excel 2003 SP2, xlodbc.xla installed. use sqlrequest connect to ms sql
7.0
In one excel cell, I put bellow formula:
=SQLREQUEST("DSN=sql-sg;UID=scala;PWD=scala;Database=scalaDB",
"select SC11003, SC11007, SC11004, SC11005, SC11015 from SC115300 where
SC11001 = '33552000' order by SC11001",,2,FALSE)
If I run above sql query from SQL Query Analysis, it returns:
0053900060 Water Technology AG & CO KG 76 -768.0 1
0000001997 76 1728.0 A
0053900061 Water Technology AG & CO KG 76 -1920.0 1
0000001998 76 1920.0 A
0000002010 76 2400.0 A
0053900041 Water Technology AG & CO KG 76 -2400.0 1
0053900062 Water Technology AG & CO KG 76 -1920.0 1
But in excel only return 0053900060. it looks like Excel can't display
whole recordsets.
Any clue?
thanks in advance
Xu Zuoyin
7.0
In one excel cell, I put bellow formula:
=SQLREQUEST("DSN=sql-sg;UID=scala;PWD=scala;Database=scalaDB",
"select SC11003, SC11007, SC11004, SC11005, SC11015 from SC115300 where
SC11001 = '33552000' order by SC11001",,2,FALSE)
If I run above sql query from SQL Query Analysis, it returns:
0053900060 Water Technology AG & CO KG 76 -768.0 1
0000001997 76 1728.0 A
0053900061 Water Technology AG & CO KG 76 -1920.0 1
0000001998 76 1920.0 A
0000002010 76 2400.0 A
0053900041 Water Technology AG & CO KG 76 -2400.0 1
0053900062 Water Technology AG & CO KG 76 -1920.0 1
But in excel only return 0053900060. it looks like Excel can't display
whole recordsets.
Any clue?
thanks in advance
Xu Zuoyin