read excel records in asp not refreshing (is the excel file cached)
Please support our ASP advertiser: DiscountASP.NET – 3 Months Free on Classic ASP Web Hosting
 |
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!
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!
|
Similar Threads
Other Threads in the ASP Forum
Other Threads in the ASP Forum
- Previous Thread: how to sum the cells in excel using asp
- Next Thread: Asp applications
•
•
•
•
Views: 15945 | Replies: 1 | Currently Viewing: 1 (0 members and 1 guests)
Linear Mode
