Greg,
This may not be the desired option...
We often create a refreshable file with the standard XA names...but we
then insert a pivot table that contains the user desired information /
report. Within the pivot table, we rename the column headings to be
more friendly. Users can then refresh the data and the
pivot...retaining the headings.
Alternatively, we have several 'reports' that have standard headers and
the imported information displays before the headers. We set Excel to
not include the field names...
Other times (and I know this probably not the most efficient...but is
effective for us)...we create logical views and rename the columns as
desired. We then refresh using the logical.
I would like to see if anybody gives a direct answer...but we have
'worked around' it as above...
Chuck
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 Greg Wenzloff
Sent: Thursday, June 23, 2011 10:21 AM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] Data transfer question
I need to transfer the contents of a MAPICS file into an Excel
spreadsheet.
When I do this I get column headings such as ORDNO.
Is there something I can do to get different column headings other than
the field name.
Perhaps ORDER NUMBER.
I want to automate this and not go into Excel to adjust column heading
each time this transfer is run.
Thanks,
Greg
_______________________________________________
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.
midrange.com
