URGENT : only 255 characters uploading from excel to sql server.why?

[Karan_TN]

i m uploading excel to database. the excel consist of a field "comments" which caarry more than 2000 characters. but when i m trying to upload, it takes only 255 characters and remaining are omitted. how to resolve it?. help me... thanks in advance - KARAN

[MHASSANF]

you must change the type of youre Column in the database to "ntext"

[Karan_TN]

thanks mhassanf.... i set as nvarchar(3000). but eventhough i cant find solution. just refer my previous post plz. help me. http://www.codeproject.com/script/Forums/View.aspx?fid=12076&msg=2550129