The process cannot access the file because it is being used by another process in C# asp.net

Asked Jun 17 '19 at 07:45

Active Jun 17 '19 at 07:46

Viewed 143 times

Unable to upload excel file again once it is uploaded recently

 string OleDBconstring = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties=\"Excel 12.0;HDR=YES;\"";            
            OleDbConnection OleDBcon = new OleDbConnection(OleDBconstring + "");
            OleDBcon.Open();`enter code here`
            DataTable objSheetNmDt = OleDBcon.GetSchema("Tables");

            DataTable objExcelDt;
            objExcelDt = new DataTable();
            string sqlquery = "Select * From  [" + objSheetNmDt.Rows[0]["TABLE_NAME"].ToString() + "]";//[{0}]                   
            OleDbCommand objCm`enter code here`d = new OleDbCommand(sqlquery, OleDBcon);
            OleDbDataAdapter da = new OleDbDataAdapter();
            da.SelectCommand = objCmd;
            da.Fill(objExcelDt);

edited Jun 17 '19 at 07:46

Dmitry Bychenko

180,369
20
160
215

asked Jun 17 '19 at 07:45

Farhad Miyaji

1

Do you have the excel file open using Excel? – Steve Jun 17 '19 at 07:47
Can you use [Process Explorer](https://learn.microsoft.com/en-us/sysinternals/downloads/process-explorer) to look up the file handle and see what process is using it, and then add that to your question? – ProgrammingLlama Jun 17 '19 at 07:47
it could be as simple as its being virus scanned – BugFinder Jun 17 '19 at 07:48
Try to use using statement on every disposable part. This way you will overcome "being used" problem – Tomáš Filip Jun 17 '19 at 07:49

The process cannot access the file because it is being used by another process in C# asp.net

0 Answers0