Import an Excel File

Question

Hi frnds,

 

I have some doubt in Excel file Import on C#. While I am trying to upload an excel file to store data in the database. But In my excel file one column contains a varchar data type in backend.

 

I am trying to upload a series of numeric characters in the column. But, In between string values are there. When am trying to upload the file the string value contained data was null values in the data table.

 

When am trying to add the string contained row data at the first line in the file. It will be uploaded.

 

Please help me out of this.