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

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,
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by 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 [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.