can access do this?

[Stuart Turrell]

I bet my answer is YES, but i just want to check.

I have a Vantage Pro Weather station that records, wind, rain, temp,
humidity etc.. and it gets uploaded via a serial cable to my computer on
COM1.

Can i create an access database to record all information that comes off my
weather station.

There is software out there to do this, but i want to create my own so i can
dictate what reports i can call off and how to display the information.

Also, once i have successfully done this, can i then (in a few months time)
upload data "live" to the internet in the form of graphs/tables for use on
web browsers and WAP phones (xml).

Many thanks

Stuart

 

[Guest]

To pull the data directly from the com port would require some pretty
advanced VB coding. If you can get the data into a text file, then import it
manually, would be fairly easy.

 

[Jerry Porter]

I worked on an Access application several years ago that read weights
from a scale through a serial port. So it is possible, though it does
take some complex code.

Jerry