Re: SQL Casting/Exponential Notation

Michael,

Check out www.easy400.net . They have some utilities (XLPARSE2/XLSTABLE)
that allows you to convert easily an Excel table to a PF file.

HTH,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--




On Thu, May 17, 2012 at 12:53 PM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

Thanks John...what would you suggest to make the transition to Excel
easier? HSSF would probably be more than could be handled.

- Michael

On Thu, May 17, 2012 at 1:20 PM, John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

On Thu, May 17, 2012 at 12:54 PM, Michael Ryan <michaelrtr@xxxxxxxxx>

wrote:

Sigh...yes, of course it's an Excel issue. Sorry for the post...I was
making expectations that I shouldn't have made. Thanks for the help.

No worries.  Now, even though the case is closed on the culprit, there
is still the issue of what to do about it.  Excel, for all its faults,
is a pretty good end-user application, and certainly an application
huge numbers of people are comfortable using.  If this data is
normally going to be opened in Excel, it is probably worth it to
implement a way to deliver the data in a form that Excel won't mangle
(which is what I offered further help with, if needed).

John
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.