× 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.






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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.