Re: Data transfer question

Try using SQL for this:

Example:

select lstnam as "Last Name" from qiws/qcustcdt

-or-

select lstnam as LastName from qiws/qcustcdt

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: [email protected]
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT


-----Original Message-----

message: 1
date: Thu, 23 Jun 2011 10:21:23 -0400
from: "Greg Wenzloff" <[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.