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

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  

For more ASP.NET Interview Questions Click Here
Categories