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!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.