The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.

See more:

ASP.NET

Hello,

I am trying to insert an table data from excel to sql server but facing the following problem..

The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.

Line 68:             OleDbCommand oledbcmd = new OleDbCommand(exceldataquery, oledb);
Line 69:             oledb.Open();
Line 70:             OleDbDataReader dr = oledbcmd.ExecuteReader();
Line 71:             SqlBulkCopy bulkcopy = new SqlBulkCopy(sqlconnectionstring);
Line 72:             bulkcopy.DestinationTableName = sqltable;

My Code

protected void importdatafromexcel(string filepath)
       {
           string sqltable = "PFDummyExcel";
           string exceldataquery = "select EmployeeId,EmployeeName,Amount from [Sheet1$]";
           string excelconnectionstring = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties=Excel 12.0;Persist Security Info=False";
           string sqlconnectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["HRGold"].ConnectionString;
           SqlConnection con = new SqlConnection(sqlconnectionstring);
           OleDbConnection oledb = new OleDbConnection(excelconnectionstring);
           OleDbCommand oledbcmd = new OleDbCommand(exceldataquery, oledb);
           oledb.Open();
           OleDbDataReader dr = oledbcmd.ExecuteReader();
           SqlBulkCopy bulkcopy = new SqlBulkCopy(sqlconnectionstring);
           bulkcopy.DestinationTableName = sqltable;
           while (dr.Read())
           {
               bulkcopy.WriteToServer(dr);
           }
           oledb.Close();
       }

Please tell me how will i solve this..