×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Greg-
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 Driver:
com.ibm.as400.access.AS400JDBCDriver
JDBC URL:
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.
-Tom Stieger
IT Manager
California Fine Wire
-----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.
midrange.com
