Loading

OleDbDataAdapter - Excel - Issue

Prakash

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Alan19y ago
Just checking but is the temporary Excel file itself actually closed when you attempt to delete it?
0