extract data from a webpage??

[wancherng]

Assume there are webpage-A and webpage-B.
Webpage-A contains a table of data which will be refreshed(or updated) every moment.
I would like to know how can I use VB.Net to write an ASP page to extract the data in real time so that I can use the data later in the Webpage-B?

[Sonu Kapoor]

I assume that the data of webpage A is saved in a backend database, before it refreshs every moment. So you can read the database with webpage B every moment and displays the chart.

If you dont have any access to the data of Webpage A, then I think its nearly impossible to read the data or you have to be very tricky to do so.

hope this helps a bit.

..sonu

[itmahatma]

If i have understood the problem correctly, u would like to pass the value to webpage-B from webpage-A, and this time its a table.. if that is the scenario why don't you expose a collection object from webpage-A and retrieve it at webpage-B.

do tell me if it helps.

[wancherng]

I think I better tell u the complete explanation of my problem:
(I am using VB.Net)hope u all can help me, thanx..


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??