|
On Tue, Jan 15, 2013 at 6:49 PM, Richard Schoen <richard@xxxxxxxxxxxxxxx> wrote:This is why I suggested using the tool to set the number format of the cell to text before putting the data there. This should be doable in code - I always suggested that when using RJS' RPG2SQL Integrator, and it always worked. No extra data either. :) I believe Richard may have been referring to this when he said "Excel formatting".
-snip-
Usually the single quote resolves the problem, but the Excel formatting may also.He didn't say single quotes didn't work; he said that using them
wasn't an option. This would make sense, as single quotes are only a
way *within the Excel program* to manually force cells to be text.
This isn't practical if a lot of data needs to be fixed or if the
processing has to be fully automated. Injecting single quotes
programmatically into a data file will either be ineffective or will
introduce unwanted data (namely, the single quotes themselves).
As an Amazon Associate we earn from qualifying purchases.
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
