| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Hybrid Mode
