Darren has attended:
No courses
Excel online connection
Is is possible to connect a websites visitor hit counter to an online excel document, therefore showing a graph of how mnay customers are coming to the site monthly?
RE: Excel online connection
Darren,
You can store hits to a text file, then import that textual data into Excel. This is easier because it is plain text you are storing (numbers, csv). An Excel file is binary and much more complicated to put together.
This page shows you how to store hits into a text file using ASP:
http://www.freevbcode.com/ShowCode.Asp?ID=359
This page shows you the same using PHP:
http://www.totallyphp.co.uk/scripts/text_file_hit_counter.htm
You'll need to have ASP or PHP installed on your server (if you're unsure, ask your hosting provider). You can also use Perl or any other CGI script, which you'll find plenty when doing a web search.
However, you'd be best to use something like Google Analytics to get data on your visitors. It's just a small bit of javascript code you add to your template or every page on your web site. Much easier - and they do all the graphs for you.
Regards, Rich
