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.


This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].