Tuesday, February 8, 2011

Excel Import Over 255 Characters

Another Excel gotcha!!!  I have a SQL column called myText and it is a varchar(2500), but when I tried to import the appropriate cell, I kept getting null values returned.  If my cell was 255 characters or less, I would be fine.  The first hint was in the sample preview for cell formating.  Anytime I saw hash marks in the sample box, my text would not import.

Here is how I fixed it!  Added a Custom "text" Type, and all the hash marks disappeared!

No comments:

Post a Comment