Hello Friends

    I have two columns in my Excel file and in my table of sql server also named as item_no and price..I have taken item_no as varchar(50) and price as money data types..I writen code to export from excel to sql server in C#.Net with ASP.Net..All the values where exporting from excel to sql server except numbers values in item_no column and it is inserting NULL instead of numbers..Can any help me where i was going wrong..I tried using nvarchar also..In the item_no i have charcter,numbers and special characters also.


Thanks
Basanth

hi there.. some code please?? looks like you are not reading any data.. or are inserting the wrong one...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========