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.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ASP.NET Interview Questions

What is difference between response.redirect and server.transfer ?

2 Answers   Kalinga Software, Satyam,


We are using Jscriopt validations and at clint site javascript is not running that time validation would work? if yes then how it would behave?

0 Answers  


how to use web services with code?(with example code)

1 Answers   Accenture,


what is diffrance between response.write & response.output.write

4 Answers   CTS,


What is enableviewstate in asp net?

0 Answers  


Why is global asax is used?

0 Answers  


Explain how viewstate is being formed?

0 Answers  


What is difference between asp state management and asp.net state management? How can we pass info between 2 asp.net pages?

0 Answers  


What is the difference between pathparam and queryparam?

0 Answers  


AJAX - explain the concept and some controls like update panel, tabcontrol etc

2 Answers   Syntel,


In my code i have 3 tables,i have to insert 3 tables data using single insert query so that i wrote transations in a sp.but what my problem is,in those 3 tables i have to include my empId from another table.when i'm passing values im getting error at this EmpId. how can i solve this error to execute insert query? plesae tell me the solution...

1 Answers  


What is a page life cycle? What are the events in a page life cycle?

0 Answers  


Categories