You haven't given much information about how you're doing the conversion from Excel to IBM i DB. What I normally do is export Excel to CSV. Create an IBM i DB table that is compatible with the CSV layout. Use CPYFRMIMPF to copy the CSV to that DB table, which is essentially a work file. Then write a program that copies the records from the work file into the final DB table, but uses logic and data conversion functions to clean up the crap that often appears in the CSV.

-Nathan.



----- Original Message -----
From: thomas burrows <thomas.burrows.1957@xxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Cc:
Sent: Monday, April 23, 2012 11:26 AM
Subject: Question on Excel to iSeries PF transfer - dates

Having some problems getting my dates to come across correctly on an Excel
to iSeries transfer. Where the iSeries connector button has been installed
on the EXCEL spreadsheet. i.e. There is a DLL that has to be moved to the
correct folder.

Anyway I am getting a number that appears to be something like the number
of days from some point in time. Not getting iSeries dates.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].