|
I take your point that double quotes around the values in a CSV file may not be enough, but I think if you're downloading directly from DB2/400 to Excel (say using CA), then there should be a way -- and if there were, I wouldn't even have bothered trying CSV. DB2 knows it's a text field, and it doesn't seem impossible that it should be able to communicate that. I don't know where the problem is, and I'm not blaming anyone, but it sure seems like a weakness to me. . . PC Technical Discussion for iSeries Users <pctech@xxxxxxxxxxxx> writes: >How is Excel supposed to know? Guess? That is the problem I am talking >about. Surveyor/400 wasn't telling Excel they were text fields. Mike Naughton Senior Programmer/Analyst Judd Wire, Inc. 124 Turnpike Road Turners Falls, MA 01376 413-863-4357 x444 mnaughton@xxxxxxxxxxxx
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
