Sqlrequest only return one value

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top