Re: Data transfer question

Thank you Jose and others who offered good suggestions.

I followed Jose's technique which is quite simple.....  

Thanks again,
Greg 

-----Original Message-----
From: [email protected] [mailto:[email protected]] 
Sent: Thursday, June 23, 2011 11:16 AM
To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]
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-Zwy7GipZuJhWk0Htik3J/[email protected]
[mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Greg Wenzloff
Sent: Thursday, June 23, 2011 7:21 AM
To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]
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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.