Re: Transfer date fields from Excel to DB2

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

Curt,

What kind of problems are you having?


Just yesterday I helped our accountant use the Excel plug-in to transfer 
a report to an Excel spreadsheet. 


        * Jerry C. Adams
*iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Curt Vancalster wrote:

> I have an excel spreadsheet that I want to import into a DB2 file.
> There are a couple of date fields in this spread sheet.  The DB2 file
> has the same date fields described as follows:
>
>
>
> Field                             Field                       
>
> Text                              Name                Type     Length
> Dec 
>
> Last_sale                      LAST_SALE      Z          26      
>
> Balance_forward            BALAN00001     A          1      
>
>
>
>
>
> I am struggling with a way to do this and I am at the point now where I
> want to just import from excel to a separate DB2 file but create the
> date fields as text in this new file.  Then create a conversion program
> to populate the DB2 file above from the file with the date fields
> described as text fields.  Confused yet?  :-)
>
>
>
> Is there another way of doing this...possibly an easier way?  I am
> having a hard time believing that there isn't an easier way to do this.
> I am currently using the Data Transfer to iSeries that is in iSeries
> navigator V5R2's to attempt to do this but without any luck.
>
>
>
> Thanks,
>
>
>
> Curt VanCalster
>
> Lead Programmer
>
> Smithfield Beef Group., - Green Bay, WI
>
> (920) 406-1174
>
> curt.vancalster@xxxxxxxxxx
>
>
>
>