×
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.
From: thomas burrows
See page twenty seven of document.
I looked at the document you mailed privately. Unfortunately that Client Access COM utility that your using to transfer from Excel to an IBM i DB table can't handle garbage that users often enter into Excel cells. It appears that you have a problem with some badly formatted data in your date column. I don't know that for sure. It just seems likely. Excel can also be quirky. Every Excel spreadsheet conversion I've ever done needed an RPG program to handle either garbage data, or unexpected quirks. The Client Access utility would be a good idea if you could guarantee that the spreadsheet always had properly formatted data and all valid values.
We've gone so far as writing Web applications that look and behave like spreadsheets, but validate each cell during data entry, so users get the most productive user interface possible, and we get valid data up front, rather than having to write a program to clean up the garbage afterwards.
-Nathan
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
