views:

23

answers:

1

I want to design a website which displays on loading two tables each with it's respective data from a csv file. Then every minute the website automatically refreshes.

This problem seems so simple! But yet the solution eludes me.

All of the files will be contained in 1 directory, not on a server but on a local machine. Such as sitting on the desktop. I understand if I use javascript I have to use ADO, and I'm still trying to work out how to use ASP. I am new with both languages. So far the only restriction is that I can't use PHP.

So the jist so far as I can think right now is: 1. read the file 2. place the file into an array by splitting at the commas 3. write the array into td's ????? 4. then print all this out into a div ????

I have googled my heart out and can't seem to find what I'm looking for. or even piece together what I'm looking for. Everything with javascript and ADO's leads me to dead ends, I can't find anything on ASP that is helpful.

Could someone please write up some sample code for a resource? Or have a better solution?

A: 

Not sure if this will be much help but have a look at the Microsoft TechNet Script Center

But as Matthew Flaschen has stated you will need to work out where the HTML will reside. either local or on a server.

Other Useful Resources
Read a CSV File Using Database Techniques
Parsing Comma-Separated-Values Logs
Write Text To Files

Nathan Fisher