Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 23, 2008 03:48 PM by satalaj
Apr 23, 2008 12:41 PM|LINK
In my excel sheet1 I have some records. The column name xyz contains some alphanumeric text and smoe pure numbers.
When I do select xyz from [sheet1$] it shows me only numbers and not the alphanumeric text.
I tried formatting the entire column into text and again fired the query I still not resolved the problem
Apr 23, 2008 01:29 PM|LINK
CAST('xyz' AS nvarchar(25))
Apr 23, 2008 03:00 PM|LINK
Apr 23, 2008 03:48 PM|LINK
This Thread of www.asp.net has given a solution.
especially rstepan post.