Posted on: 10/18/2013 8:23:53 AM | Views : 711

I am trying to Import Excel Sheet Data into Database but it's giving error "The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.".
protected void  btnImport_Click(object sender, EventArgs e)     {         string excelConnectionString = "";         string strFileType = Path.GetExtension(FileUpload1.FileName).ToLower();         string path = FileUpload1.PostedFile.FileName;         //Connection String to Excel Workbook         if (strFileType.Trim() == ".xls")         {             excelConnectionStr ...

Go to the complete details ...