SQL.REQUEST - Driver Prompt 1

[LevelThought]

Using SQL.REQUEST function within Microsoft Excel (2000) to extract data from an Oracle 8.1.7 database.

Format of SQL.REQUEST function is = SQL.REQUEST("DNS=FCC; UID = jt_jacxw; PWD = 2ABDcv;,,,"Select * from Account_Review")

Upon opening the Excel workbook, I am prompted 4 times with the Microsoft ODBC for Oracle dialog box and then I have to enter the server name each time before the correct values are displayed in the 4 cells that the function is entered in!

Any clue as to what is the problem and a resolution? Or, is this the way that the SQL.REQUEST operates whereby a dialog box will appear...?

 

[ddiamond]

try specifying driver_prompt parameter:
SQL.REQUEST("DNS=FCC; UID = jt_jacxw; PWD = 2ABDcv;",,4,"Select * from Account_Review")

Also, the code you posted is missing a quotation mark. I assume the quotation mark was in your actual excel formula, otherwise you would have gotten an error.