Re: Retrieving data from iSeries using Excel

<verndor response>
How about working the other direction? Our RPG2SQL product also has OLE 
automation for Excel - you could read the emp number in an RPG program, get the 
stuff you need from your PF, then write back out to the Excel spreadsheet.

If interested, check our site at www.rjssoftware.com or call me at 952.898.3038

</verndor response>
-------------- Original message -------------- 
From: MckayS@xxxxxxxxxxx 

> 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 
> 
> -- 
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing list 
> To post a message email: PcTech@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/pctech 
> or email: PcTech-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/pctech.