When you are going to use Ms Excel in c#, If you get this error when importing a excel file use this connection string Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +Server .MapPath("Master.xlsx") + ";Extended Properties='Excel 12.0;HDR=YES;'" "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.
C#, VB.NET, SQL Server ,ASP.NET and Crystal Report and Net for Beginner.