I've been doing this a very, very long time, and I believe the problem has pretty much always been around. But every once in a while it becomes a real PITA and I troll the information superhighway looking to see if an answer has been found.
I exchange a lot of CSV files with all kinds of people, both computer literate and computer ignorant. Sometimes the data includes account numbers that begin with a 0 and when the file is opened by Excel, it will change those accounts to number fields and strip off the leading 0.
Now, I know that I can make the field text and do a data import and make those fields Text, but when a CSV file with 50 columns is going to Bob "I don't know anything about computers and get confused real easy" Smith, that's not an acceptable answer because he's invariably going to complain, "This is too complicated. Why can't you send me one of those CSV files?"
So, here we are in the Century of the Fruit Bat and MS still doesn't seem to have a simple solution to a common problem. Is there any way to gimmick a CSV file so that Excel will open it without stripping out the leading zeros without messing the file up for import into something like SQL server?