Hi all,
I am trying to insert around 360 records from excel to sql server.. I am using sql bulkcopy for doing so.. But When I try to insert the record; I can get only 299 records imported from excel to sql server..
Delving Deep into the problem I found that In a field called Material if the value is around greater than 10 characters it is not getting inserted in the same time..
For Example I have field called material.. In which I have values like abcssdssss,asaaasssss,hajasksajhshjashsjahas etc..
So the first 2 will get inserted at a time but the last one is not getting inserted at the same time.. So for some unknown reason it is leaving the records whose material string length is greater than 10 characters...
But If i seperately try to insert the value it gets inserted... Please Suggest..
if (Path.GetExtension(FileUpload2.FileName).ToLower() == ".xls" || Path.GetExtension(FileUpload2.FileName). ...
Go to the complete details ...