Thank you Jose and others who offered good suggestions.
I followed Jose's technique which is quite simple.....
Thanks again,
Greg
-----Original Message-----
From: JoseORivera@xxxxxxxxx [mailto:JoseORivera@xxxxxxxxx]
Sent: Thursday, June 23, 2011 11:16 AM
To: mapics-l@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] Data transfer question
You can gather all column's field names and inside the Client Access
transfer change the name, like below
Select area:
ORDNO as order_number
Jose Rivera
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Greg Wenzloff
Sent: Thursday, June 23, 2011 7:21 AM
To: mapics-l@xxxxxxxxxxxx
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.
_______________________________________________
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.
_______________________________________________
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.