Sign Up Login


  1. Categories >> Software >> Microsoft Related >> ASP.NET
  2. Suggest New Category

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.

Question Posted / ramesh_tech

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

Post New Answer

More ASP.NET Interview Questions

Whta are the Various steps taken to optimize a web based application (caching, stored procedure etc.) ?

0 Answers  

WHAT IS THE SEQUENCE IN WHICH ASP.NET EVENTS IS PROCEED?

4 Answers  

Which data type does the rangevalidator control support?

0 Answers  

what if we delete web.config or machine.config? will a website work if we delete webconfig....or if we delete machine config?

4 Answers   TCS,

What is event in asp.net?

0 Answers  

How to deploy/publish webservices?How many ways?Plz explain me

0 Answers   TCS,

Any alternative to avoid name collisions other then Namespaces?

1 Answers  

What is the difference between ASP and ASP.NET?

4 Answers   Sans Pareil IT Services, TCS,

what is the exact purpose of http handlers and interfaces?

1 Answers  

What is asp.net response object?

0 Answers  

What is & in a url?

0 Answers  

What is IPostBack? How to use it?

0 Answers   MCN Solutions,

For more ASP.NET Interview Questions Click Here
Categories