×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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 mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
