|
Steve,If you don't have too many employees, one easy way to solve it would be to download the data to a separate sheet using MS/Query and then on your original sheet use the VLOOKUP function to grab this data. I've been doing this more lately and it works fine, the only caveat is to make sure you have Excel do the sorting of the AS/400 data.
Bill MckayS@xxxxxxxxxxx wrote:
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)
As an Amazon Associate we earn from qualifying purchases.
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.
