Re: excel

Pete,

Very simple.  Install Office (or Excel) first.  Then install Client Access.

A new option will appear under the "Data" option on the Excel menu,
"Transfer Data from iSeries".

Click on it.

Click on "Create New".

Enter the iSeries' name, click Next.

Enter the library/file name, click Next.

Click on Properties, change Convert CCSID 65535, click OK, click Next.

If you will be doing this transfer regularly, enter a file name and
directory to save the transfer request (then you can use it instead of
"Create New" above).

Click Finish.

The data will transfer into the Excel spreadsheet.

Reformat as desired and save.

Serve with wine, feeds 10-20.   (just kidding).


Dale Gindlesperger
IT Manager/Special Projects Leader
Fleetwood Folding Trailers, Inc.
258 Beacon Street
Somerset, PA  15501




|---------+----------------------------------------------------------->
|         |           Pete Olshavsky <polshavsky@xxxxxxxxx>           |
|         |           Sent by:                                        |
|         |           mapics-l-bounces+dalegindlesperger=fft-inc.com@m|
|         |           idrange.com                                     |
|         |                                                           |
|         |                                                           |
|         |           05/03/2004 02:31 PM                             |
|         |           Please respond to MAPICS ERP System Discussion  |
|---------+----------------------------------------------------------->
  
>----------------------------------------------------------------------------------------------|
  |                                                                             
                 |
  |       To:       mapics-l@xxxxxxxxxxxx                                       
                 |
  |       cc:                                                                   
                 |
  |       Subject:  excel                                                       
                 |
  
>----------------------------------------------------------------------------------------------|




Happy Monday Group.
Not sure there is an easy or simple answer.
Has anyone figured out in EXCEL the transfer from AS/400??? (Client Access
express 5.1)..
Is there good documentation with examples anywhere????? I am not very
skilled with excel.. Which is probably issue one.
What I am trying to do, is create an excel spreadsheet with data I
generated on the as400 via a pgm that will get run once a week.  I would
then like the user to click an icon, and the data would get transfered /
replaced to a spreadsheet that was created and saved. And retain all the
changes that I have setup in the spreadsheet.

                                    inp dte+7  +7            +7
 COMNO   Input date     99/99/99    99/99/99   99/99/99   <---     HEADINGs
  01           05/03/04       dollrs          dollars     dollrs       <---
Data from 400
The Input date fld would be used to calc the date that is 7 days, then 7
more days, then 7 more days, etc.


---------------------------------
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.