Excel file delete from server

[Murali via DotNetMonster.com]

Hi,
I am uploading the excel file to the server and reading the data and
dumping in to sqlserver.
Now i want to delete the excel file from the server, but i am getting a error
like "file in use..."
Cannot be deleted"
So, please suggest me how do i delete the file after inserting the data into
sql server.

Thanks in advance,

Murali

--
Murali
VSM Software (P) Ltd.
Bangalore,India

Message posted via http://www.dotnetmonster.com

 

[Markus]

Hi,
I am uploading the excel file to the server and reading the data and
dumping in to sqlserver.
Now i want to delete the excel file from the server, but i am getting a error
like "file in use..."
Cannot be deleted"
So, please suggest me how do i delete the file after inserting the data into
sql server.

after reading the data from the excel file, make sure, the excel file
gets closed before being deleted. then the file is not in use any
more... however, this is just a rough guess, as I don't see any of your
code.

markus