Have you tried to transfer the data directly from Excel using the
"Add-ins" (provide by iSeries Access).

I do this every time that there is a need of getting a large number of


From: "Weston Wheat" <wwheat@xxxxxxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
Date: 11/18/2010 09:42 AM
Subject: [MAPICS-L] Exporting data from PowerLink to Excel 2007
Sent by: mapics-l-bounces@xxxxxxxxxxxx

Hello All.

I have this weird problem. I cannot get a large record set of data to
export correctly into Excel

from powerlink.

It is leaving out records in the exported text file.

We are trying to export bookings data to Excel and the totals

are not matching up. Also the row count is off so we know that it is
skipping records.

I have up'ed on the Limit clipboard export to first K Chars, setting to
the max. But that didn't help.

Does anyone have any tricks that work? We are at R7.8 .


And p..s. Please don't flood this tread with a bunch of Marketing for

linked financial type appl's.

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.

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 midrange.com 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.