× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Greetings -
 
I have an Excel spreadsheet of employee numbers.  I would like to retrieve
the employee's name and address from a file on our iSeries.  I have tried to
install the Excel XLODBC.XLA add-in but it is only available for versions up
to 2002 - I am using Excel 2003.  I have also tried using SQL.REQUEST and
that holds some promise but I can't get past a #VALUE! error using the
following as a cell entry:
 
 =SQL.REQUEST("DSN=EMPXL", A2, 1, "Select EMPNAME from EMPFILE WHERE EMPNBR
= 123456789", TRUE)
 
EMPXL is the name of the iSeries Access ODBC driver on my PC.  I can
retrieve all records from EMPFILE using it.  In this case, I only want
certain records matching the employee numbers in the spreadsheet.  I'm not
locked in to SQL.REQUEST but need to use some method which is readily
available (no vendors, please!) to the normal Excel user.
 
Excel 2003, OS/400 V5R2, Win XP.
 
Any ideas?
 
Thanks in advance,
 
Steve
 

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.