![]() |
Sqlrequest only return one value
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 |
All times are GMT +1. The time now is 10:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com