Re: excel

checkout the linoma product (www.linoma.com) that does data transfer.  I'm
going to be looking at a copy of it shortly, but haven't of yet...

Don in DC



On Mon, 3 May 2004 LeLeux@xxxxxxxxxxxx wrote:

> Here's the CA 'plugin' by itself:  C:\Program Files\IBM\Client
> Access\Shared\cwbtfxla.xll
>
> I may even have a program or two lying around it you like.  Although when
> we were doing
> ODBC it was primarily thru Access.
>
> Have fun!
>
>
>
>
> Pete Olshavsky <polshavsky@xxxxxxxxx>
> Sent by: mapics-l-bounces+leleux=shur-lok.com@xxxxxxxxxxxx
> 05/03/2004 11:31 AM
> Please respond to
> MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
>
>
> 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.
>
>
> _______________________________________________
> 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.
>