This problem is can be sorted out by either

1. Select the column in excel right click ,select format cells, in category list select text  press ok. This will solve the problem .
2.  If you are using DTS wizard you are free to select the column data type
3. One more tip , just keep some alpha text filed in the first cell this will result in considering the entitre column as text (or varchar)

regards

john