>>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.
I agree. You can quote text values, but this is problematic if the data itself contained quotes. It helps some if you define the fields as text instead of general in the import screen. But there are still problems. I have tried to convince users not to overuse Excel, but they usually act like I just ran over their favorite puppy. Charles Shaffer Senior Analyst NTN-Bower Corporation _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
