Re: Copying Spreadsheet To iSeries

[Pat Barber <mboceanside@xxxxxxx>]

What method are you using for the download ?

Access or cpytoimpf  or the built-in that goes
with Excel ?

All three methods do it a "tad" differently so
the method is needed for an explanations.

On 11/22/2010 9:46 AM, Robert Munday 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