Re: Loading Offline Files from Excel
"Chuck Mick" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
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: [email protected] [mailto:[email protected]] On Behalf Of Bob Anderson Sent: Tuesday, October 05, 2010 11:08 AM To: [email protected] 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: [email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: [email protected] 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: [email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: [email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.