wginneke
Technical User
- Sep 17, 2007
- 1
I would like to import status-information on 3 webpages into Access-tables.
This information is updated every hour and I would like to see the changes over time.
I use the following code:
Function Refresh()
Dim table As String
' clear the existing table'
table = "[Table1]"
sqlstr = "DELETE " & table & ".* FROM " & table & "; "
DoCmd.RunSQL sqlstr
'import new data'
DoCmd.TransferText acImportHTML, "Import Specification", "Table1", " False, ""
End Function
This function puts data from the webpages in the tables, but strange enough this doesn't seem to be consistent: sometimes I get the most recent information in all 3 tables, sometimes one ore more of the tables show the old information again (even after i have cleared the contents of the table)
anyone any idea what's causing this behaviour? (information retrieved from IE-cache?)
This information is updated every hour and I would like to see the changes over time.
I use the following code:
Function Refresh()
Dim table As String
' clear the existing table'
table = "[Table1]"
sqlstr = "DELETE " & table & ".* FROM " & table & "; "
DoCmd.RunSQL sqlstr
'import new data'
DoCmd.TransferText acImportHTML, "Import Specification", "Table1", " False, ""
End Function
This function puts data from the webpages in the tables, but strange enough this doesn't seem to be consistent: sometimes I get the most recent information in all 3 tables, sometimes one ore more of the tables show the old information again (even after i have cleared the contents of the table)
anyone any idea what's causing this behaviour? (information retrieved from IE-cache?)