Re: Retrieving data from iSeries using Excel

You could try the Client Access ODBC driver.  There's also a product called
Showcase from SPSS (www.spss.com) that works well populating spreadsheets
with iSeries data.  It's simple but depending on how much you want to use
it, it may be more than you need.

Dave Parnin
--
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxx





                                                                                
                              
                      MckayS@xxxxxxxxxx                                         
                              
                      m                        To:       pctech@xxxxxxxxxxxx    
                              
                      Sent by:                 cc:                              
                              
                      pctech-bounces@mi        Subject:  [PCTECH] Retrieving 
data from iSeries using Excel    
                      drange.com                                                
                              
                                                                                
                              
                                                                                
                              
                      02/22/2006 05:02                                          
                              
                      PM                                                        
                              
                      Please respond to                                         
                              
                      PC Technical                                              
                              
                      Discussion for                                            
                              
                      iSeries Users                                             
                              
                                                                                
                              




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.