View Single Post
Join Date: Mar 2005
Posts: 131
Reputation: william_stam is an unknown quantity at this point 
Solved Threads: 2
william_stam's Avatar
william_stam william_stam is offline Offline
Junior Poster

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

 
0
  #1
May 7th, 2005
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!
Reply With Quote