I am beginner (still a student) to prgramming and need some guidance.
(I am using VB.Net)
Assume therer are two website-->websiteA(my own website) and websiteB(someone else's website).
I need to extract data fromwebsiteB(data in a table) and display the data in a chart.

Because the data in websiteB is updated every moment, i might need to store the old data in a database for me to plot the graph/chart(value against time) later.
The way I am doing is using Access and Excel manually.
I want to use ecxel to do a web query and extract data from websiteB and the let excel's webquery refreshes every minute.
I am able to create a macro(using transferspreadsheet method) in access to append the updated/refreshed data to the previous data from excel but i can't set the macro run automatically every minute(synchronize with excel). How do i solve this??
I know that if all this is done entirely by writing code in ASP, it will be more professional and less problem, but I don't know how should I start the code because i am not sure the coding to control excel and access in VB.net(such as data connection etc.).
So, what is the best way to solve this problem??
If it is possible, could anybody show me how to do this by truely coding in asp??