importing from excel into sql server

the value shows as TEXT in excel. but the one without the corner shade (top left) gets in fine, the other comes in as NULL.

i tried importing as varchar(255) still comes in as NULL.

How can we overcome this?
2-text-but-One-Fails.bmp
LVL 6
anushahannaAsked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
Here is a very good explanation of the problem and how it was addressed using DTS:
PROBLEM: Why does Excel Insert NULLs into my table when I know there is good data in there?
http://www.sqldts.com/254.aspx
0
 
anushahannaAuthor Commented:
i am using the import wizard..
0
 
anushahannaAuthor Commented:
i tried float & decimal also- they also got the same error.
0
 
Mark BradyConnect With a Mentor Principal Data EngineerCommented:
Post the excall spreadsheet here and I will see if I can get it imported into MySql. If it works I will export it as an .sql file and send it back to you. I can't help unless I can see the problem because I have never heard of that problem (with the shading in the corner).
0
 
anushahannaAuthor Commented:
thanks- that link provided the answer..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.