I am using OleDbDataAdapter to import the data from the Excel. I am making temporary excel file and open the connection and fill the data to the data table. After closing the connection, i am not able to delete the temporary excel file. It says another process using the file.
I set all the objects to null, still the problem came.
Let me know the solution for this problem.
Regards
M.Prakash