Bob,
I have used Excel and Access on various occasions to update the XA
offline files...and then run the offline programs within XA. I believe
you can create an ODBC and update the iSeries offline files directly
from Excel...but I have used Access since I found that easier.
As a starting point - have you looked at the file layouts for the XA
offline file loads?
If this sounds like what you are looking for -- give me a call or email
directly and I will try to assist.
Have a great day.
Chuck Mick
Diversified Machine Inc.
(o) 248.277.4315
(m) 517.643.3548
Â
Confidential: This electronic message and all contents or attachments contain information from Diversified Machine, Inc. which may be privileged, confidential or otherwise protected from disclosure. The information is intended to be for the addressee only. If you are not the addressee, or have received this message in error, any disclosure, copy, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify us immediately (248-277-4311) and destroy the original message and all copies.ÂThank you for your assistance in this matter.
Â
** Please consider the environment before printing this e-mail **
Â
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob Anderson
Sent: Tuesday, October 05, 2010 11:08 AM
To: MAPICS-L@xxxxxxxxxxxx
Subject: [MAPICS-L] Loading Offline Files from Excel
Hello,
I have a requirement to load some offline data to our
MAPICS system. Currently it is in an Excel 2003 spreadsheet and I need
to get it into a file on the iSeries that I can use to load from. As I
have never done this before I have no clue on how to proceed.
Could some kind soul out there enlighten me.
Thanks very much in advance
Bob Anderson
IT Manager
Kent Sporting Goods Inc.
433 Park Ave. S
New London OH 44851
419-929-7021 x315
P Please consider the environment before printing this e-mail.
_______________________________________________
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.
midrange.com
