Re: Copying Spreadsheet To iSeries

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Robert,

Are you using the iSeries Access Excel add-in? If so, under properties,
there is an option for converting Excel Time and Date to their iSeries
equivalent...

HTH,

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



On Mon, Nov 22, 2010 at 10:16 AM, Robert Munday <rwmunday@xxxxxxxxxxxxx>wrote:

>   Greetings from sunny Florida.
>
>
>
>
>
>   An employee at the client site is attempting to copy a spreadsheet to a
>   file on the iSeries.  There are two date fields in mdcy format displayed
>   as MM/DD/CCYY.  When the data is exported, a numeric value for that date
>   is what arrives.  Ex: 10/30/2010 appears as `40481`.  How can the data be
>   exported to arrive as the intended date field?  We are using Excel 2007.
>
>
>
>
>
>
>
>   Robert Munday
>
>   Munday Software Consultants
>
>   Montgomery, AL
>
>   on assignment in Jacksonville, FL
> --
> 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.