Before the SQL Serverites start pointing too many fingers, many other products including SQLServer (or more specifically the Excel ADO code) are guilty of similar things.

Try importing a text column...