How are you doing the transfer?
I've been semi-successful using some properties on a JDBC Connection URL to bring over the column headings.
jdbc:as400://myas400.name;translate binary=true; extended metadata = true;
This would bring over a column heading looking like this: 'Order Number'
I'm not sure if there something similar with ODBC.
I think I have also had success using some of Chuck's suggestions.
California Fine Wire
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Greg Wenzloff
Sent: Thursday, June 23, 2011 7:21 AM
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.
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,
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l