Re: Exporting data from PowerLink to Excel 2007

Weston

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.

Kevin


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



Thanks

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

linked financial type appl's.

Kevin Fox
(909) 762-1384 mobile