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.
----- Original Message -----
From: thomas burrows <thomas.burrows.1957@xxxxxxxxx>
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
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 ...
Re: Question on Excel to iSeries PF transfer - dates, (continued)
This mailing list archive is Copyright 1997-2020 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