read excel records in asp not refreshing (is the excel file cached)
 

If i read excel records in asp using a recordset (to put those records into something a little better) it continues to use the old file.

step 1 - upload excel file to the server
step 2 - read excel contents writing them to database (I don't consider excel a database , technicaly it is)
step 3 - delete the uploaded excel file

The problem is that asp reads records that don't exist, like in:

File 1
ID name
1 tom
2 sam
3 bob

File 2
ID name
1 peter
2 lucky
3 john


it continues to read file 1's info even though file 1 has been deleted



PLEASE HELP

if you don't understand my request please let me know!

Re: read excel records in asp not refreshing (is the excel file cached)