sudharsan s

sudharsan s

  • NA
  • 204
  • 87.2k

error in reading excel data?

Jul 13 2012 3:56 AM

I am reading the excel data when the excel file uploading and save the excel content in my db.

now i get this error , how to rectify this error

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

code:


 else if (extn.Equals(".xls"))
            {
                string filePath = Server.MapPath("uploads/" + filename);
                //string connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1';";   // Extra blank space cannot appear in Office 2007 and the last version. And we need to pay attention on semicolon.

                string connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1';";
                    //Extended Properties='Excel 8.0;HDR=NO;IMEX=1';";  //This connection string is appropriate for Office 2007 and the older version. We can select the most suitable connection string according to Office version or our program.

                   using(OleDbConnection conn = new OleDbConnection(connstring))
                   {
                       conn.Open();
                       DataTable sheetsName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[]{null,null,null,"Table"});  //Get All Sheets Name
                       string firstSheetName = sheetsName.Rows[0][2].ToString();   //Get the First Sheet Name
                       string sql = string.Format("SELECT * FROM [$Sheet1],firstSheetName");  //Query String
                       OleDbDataAdapter ada =new OleDbDataAdapter(sql,connstring);
                       DataSet set = new DataSet();
                       ada.Fill(set);
                       //set.Tables[0];  
                   }

query = @"INSERT INTO Fileupload([category],[subcategory],[uid],[oid],[up_name],[demo1],[keyword],[fdata],[aflag],sizebyte)
VALUES(@category,@subcategory,@uid,@oid,@up_name,@demo1,@keyword,@fdata,1,@sizebyte)  ";
                SqlCommand command = new SqlCommand(query, con);
                //command.CommandText = command.CommandText.ToString();
                command.Parameters.AddWithValue("@category", dropcategory.SelectedValue.ToString());
                command.Parameters.AddWithValue("@subcategory", DropDownList1.SelectedValue.ToString());
                command.Parameters.AddWithValue("@uid", Session["user_id"].ToString());
                command.Parameters.AddWithValue("@oid", txtOwnerId.SelectedItem.ToString());
                command.Parameters.AddWithValue("@up_name", fname);
                command.Parameters.AddWithValue("@demo1", demo1.Text);
                command.Parameters.AddWithValue("@keyword", key);
                command.Parameters.AddWithValue("@fdata", );
                command.Parameters.AddWithValue("@sizebyte", size);
                command.ExecuteNonQuery();

            }


Answers (3)