Grabing HTML Table from WWW into VB App

[scoombs]

Hi All,

I was after some advice first of all.

I want to create a program/application that looks at certain tables on certain html/asp sites.

I think the best approach would be for it to download the table say every 1 minute then log the data in a table and then display this data on a VB form.

The tables are of Airport Departure data, for the purpose of the exercise I am using

http://www.bristolairport.co.uk/flight_information/departures_board.aspx

for the table. In the past I have had this table extracted into xls and created a macro to re-downloaad it and save the file ever minute which works fine but will not do for the neext step of my project.

The other problem is I only want 12 records to display and after 5-10seconds the next set of 12 records with a maximum number of pages of 5 so 60 records in total.

I guess the 12 records per page would have to be hard coded and the 5-10secs could be chhanged in a settings field for example as well as total number of records to display.

If anyone can give me any advice on an approach to take and how you would do it it would be most appriciated.

Regards,



Steve Coombs