Print Page | Close Window

A data monitoring ASP

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=1096
Printed Date: 28 March 2026 at 3:11pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: A data monitoring ASP
Posted By: wancherng
Subject: A data monitoring ASP
Date Posted: 17 March 2003 at 11:25pm

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




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net