IF you are using IBM Client Access there are MANY options available. IF
you install Client Access after Excel has been installed, CA will install
a button into Excel to retrieve data. Otherwise you have to do it
manually....still not that difficult.
Create an ODBC connection to the iSeries server and library for your data
Open an Excel spreadsheet.
Go to Data, Get External Data, New Database Query
A window, Choose Data Source, pops up. Select your ODBC connection
...the rest is pretty intuitive.
You can also run reports from Microsoft Access. You LINK your data files
to the files on the iSeries server. Create your queries and reports
pretty much vanilla Access and you have reports.
Norman K. Boyd
Showa Aluminum Corp. of America
CONFIDENTIALITY NOTICE: This e-mail message is intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message. If you are the intended recipient but do not wish to receive
communications via email, please advise the sender immediately.
"BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
07/29/2009 05:41 PM
Re: [BPCS-L] Connecting Excel to BPCS
We use sql all the time an there is an iseries transfer option in excel
that will transfer data between excel an the iseries
Sent via BlackBerry by AT&T
Date: Wed, 29 Jul 2009 09:28:27
Subject: [BPCS-L] Connecting Excel to BPCS
What is the best way to retrieve data from BPCS? I am completely new to
BPCS, and we have version 5.5. Can you connect via Excel, or do you
need other addins and/or SQL to get at the data? Any information would
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2021 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
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.