Re: Data transfer question
Tom E Stieger <testieger-7y5+ka1ulstWk0Htik3J/[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
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-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.