I have an excel file with data, i am importing this excel file
data into Sqlserver 2005 database. while importing i am
getting wrong data(ie, special characters) in one
column(description column), upto some limit the data in that
column is coming fine,after that data is coming like below.

The "Walter" leather storage bench is one of our most
popular styles. The top with the tufting and double
stitching finish a very impressive piece. The size is
perfect in front of beds and the storage adds another
functional bonus. Open it up and sneak al���Ƴ�Â��ƴ�Ã��ƶ�Å��
al���Ƴ�Â��ƴ�Ã��ƶ�Å��

Is there anywhy to resolve this?
(I am using recordset in coding for developing import process.)

please help me soon.