 |  |  |  |  |  |  |  |
read excel records in asp not refreshing (is the excel file cached)
Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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
- Previous Thread: how to sum the cells in excel using asp
- Next Thread: Asp applications
| Thread Tools | Search this Thread |
Latest ASP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for ASP
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection calendar changeable connection current database databaseconnection diagnostics dreamweaver excel fso html iis microsoft msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile record searchbox selectoption server single specfic sqlserver sqlserverconnection toolkit web webserver windows7
