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 ...