943,793 Members | Top Members by Rank

Ad:
  • ASP Discussion Thread
  • Unsolved
  • Views: 17182
  • ASP RSS
May 7th, 2005
0

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

Expand Post »
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!
Similar Threads
Reputation Points: 10
Solved Threads: 2
Junior Poster
william_stam is offline Offline
131 posts
since Mar 2005
Oct 20th, 2006
0

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

Reputation Points: 58
Solved Threads: 1
Posting Whiz in Training
cancer10 is offline Offline
234 posts
since Dec 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP Forum Timeline: how to sum the cells in excel using asp
Next Thread in ASP Forum Timeline: Asp applications





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC