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

Can u able to get the xml document in crystal report if yes how its possible

2 Answers  


What is the name of the base class that all web forms will be inherited?

7 Answers  


How can u deifne the benefits and limitation of using Viewstate for state management?

0 Answers   QuestPond,


what is the difference b/w Asp.net server controls and html server controls in .net?

2 Answers   iGate, Profiniti Systems,


How would you get ASP.NET running in Apache web servers - why would you even do this?

1 Answers   Siebel Systems,






Explain serialization and deserialization?

0 Answers  


What are merge modules?

0 Answers  


How many types of session in ASP.NET

0 Answers   MCN Solutions,


How does a web application session work?

0 Answers  


Is asp.net mvc front end or backend? : Asp.Net MVC

0 Answers  


What are sql joins?

0 Answers  


What is the main difference between grid layout and flow layout?

1 Answers  


Categories