 |  |  |  |  |  |  |  |
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 |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest ASP Posts
- Today's Posts
- Unanswered Threads
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection connection database databaseconnection dreamweaver excel fso iis msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile record searchbox selectoption single specfic sqlserver sqlserverconnection windows7
