I agree completely. However, Excel has the nasty habit of doing things to the
data. For example, leading zeros are removed from numeric data. This is a bad
thing if you have valid data like 123, 0123 & 00123. Excel will make then all
123. Sure, I can put quotes around them, but when the folks that use macros
and pivot tables, or tie into other Excel files, these will not work ("00123"
does not equal 0123 in Excel). Big numbers, like GL#s get converted to
scientific notation. Some numbers or text get converted to dates.
Argh!!!
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH 45342
937-866-0711 x44380
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Monday, July 06, 2009 9:58 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel
I second what Charles is saying. When moving data into Excel, tab-sep format
is a lot cleaner because you don't have to care whether a field has an
embedded comma, squote, or dquote.
-K
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
