Cold Fusion Excel Data Source

I have created an excel DSN in cold fusion Administrator.My program will read the data from the excel sheet and then delete that excel file.
For reading from excel file i am using:
<CFQUERY DATASOURCE="XL_DSN" NAME="XL_READ_USER">
SELECT * FROM User1
</CFQUERY>

After reading i want to delete the file excel file from that directory.But i am getting the error :

The process cannot access the file because it is being used by another process. (error 32)

Please help.

Thanks,
Mohapatra

Some other process has the file locked, or maybe you have it open. Excel is a "file-based" datasource, just like access, and if you have the file open and try to open a connection to it in CF, you'll get this error.

In CF Administrator i am creating the Excel DSN.Apart from the DSN, i am providing the excel file path and rows to scan as 16.

Is there anything we have to set for the Excel data source.

Mohapatra

I don't think so, but I rarely use Excel as a DSN because it performs so poorly. If you keep having problems or expect any significant use of this DSN you might consider moving the data to a real database.