Using SQLREQUEST in Excel to get AS/400 data

["Marshall Akins" <makins@xxxxxxxxxxxxxx>]

Anybody out there use the SQLREQUEST function in Excel?   I ran across this
function  and thought it would be a great way to get data from the AS/400
into an Excel cell, kinda like a lookup into the AS/400 file.   Sqlrequest
lets you execute an sql statement and returns the data to the cell.    You
have to use the ODBC add-in functions to use it.   The function within the
cell looks like this

=SQLRequest("DSN=QDSN_Hanna;UID=M_AKINS","select whname from hscflib.whpmas
where whsno = 1",,).

I found some documentation at
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9127.  This would be a
really great function except that I cannot get it to work.  All I get back
is #N/A, which seems to indicate that something is not working.   I know
that I am talking to the AS/400 because I can see that I am connected to a
QZDASOINIT and QZLSFILE job.   Nothing in the job logs though.   Any
thoughts?