Re: Connecting Excel to BPCS

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

Have fun.

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
MIS Administrator
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.



From:
larenzo_alexander@xxxxxxxxx
To:
"BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
Date:
07/29/2009 05:41 PM
Subject:
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

-----Original Message-----
From: "Aaron Brown" <Aaron.Brown@xxxxxxxxxx>

Date: Wed, 29 Jul 2009 09:28:27
To: <bpcs-l@xxxxxxxxxxxx>
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
be appreciated!



Thank you,



Aaron Brown