SQL.REQUEST Returns Single Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I enter a sql.request function in a worksheet cell, and it returns only the
first column of the first matching row of the database. How can I modify the
syntax to return all columns in all matching rows?

Thanks for the assistance. Glenn
 
Thanks James. So the sequence would be to enter the formula in a cell, but
instead of hitting enter, I should hit ctrl+shift+enter? I tried that, and
it didn't change the result. What could I be doing wrong? Thanks, Glenn
 
You have to select as many cells (rows and columns) as you expect it to
return data if you are going to try ctrl+Shift+enter. You select the cells,
go to the formula bar and enter the formula, commit with Ctrl+Shift+Enter
 

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

Similar Threads

SQL.REQUEST Returns Single Cell 1
lastrow function help 6
I need to execute the SQL.Request with SQL strings larger than 512 4
Sql.request for GROuP BY 3
SQL.REQUEST #N/A error 5
#N/A Using SQL.REQUEST 3
transformed vloopup 2
SQL.REQUEST query omitting rows in MSSQL DB 2

Back
Top