OraFAQ Forum: Windows » Extract oracel data to an excel thur ODBC

Home » Infrastructure » Windows » Extract oracel data to an excel thur ODBC

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Extract oracel data to an excel thur ODBC [message #100813]

Mon, 27 October 2003 20:17

Johnathan Chiu
Messages: 4
Registered: October 2003

Junior Member

I use the excel function on 2 cells to select data from oracle databse, one return the result and the other return '#N/A'.

The statement on the function is :

"DSN=Oracle;UID=USER1;PWD=PASSWORD;SERVER=MYSERVER","SELECT YERNAME from EMPLOYER where ENUM="&$A$1&""

*** This return the result with the correct information.

"DSN=Oracle;UID=USER1;PWD=PASSWORD;SERVER=MYSERVER","SELECT YEENAME from EMPLOYEE where ENUM="&$A$1&""

*** This return '#NA'

Please advise what's wrong with my 2nd statement on the function.

Thanks in advance.

Report message to a moderator

Re: Extract oracel data to an excel thur ODBC [message #100827 is a reply to message #100813]

Sun, 16 November 2003 09:36

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Hi,

Might be a NULL value returned from the Oracle database.
Try the following:

SELECT nvl(YEENAME, 'NO NAME') from ...

Best regards.

Frank Naude

Report message to a moderator

Previous Topic:	Oracle 9i execution in W2K
Next Topic:	Problem with OraOLEDB + Delphi

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 13:22:52 CST 2024