ExcelBanter - SQL.REQUEST

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SQL.REQUEST (https://www.excelbanter.com/excel-discussion-misc-queries/165633-sql-request.html)

SQL.REQUEST

SQL.REQUEST

Hi, my DB is Oracle and I try to connect, but this string return #value

=SQL.REQUEST("DSN=xe;UID=siga;PWD=siga";A5; 2;"Select E1_VALOR from SE1020
where E1_VALOR = '"&$A$2&"'"; VERDADEIRO)

??? Have someting wrong?

All times are GMT +1. The time now is 10:57 AM.