They best way to do this is with System-Link (web services).

It should take about 1 hour to setup, but then it runs like the wind and has built in security without the overhead of ODBC, etc.

The next best way to export large files to excel is to save as a file first, comma delimited works best and then open in excel. You may have to parse the table, but you can save your settings so that you don't have to do it on an ongoing basis.


-----Original Message-----
From: Weston Wheat <wwheat@xxxxxxxxxxxxxx>
Sent: Nov 18, 2010 9:41 AM
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Subject: [MAPICS-L] Exporting data from PowerLink to Excel 2007

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.

Kevin Fox
(909) 762-1384 mobile

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.