Capture data from Serial port

[Guest]

Has anyone ever used Access 2000 to capture data from an input device like a
serial port and stored the data in the database. I have a program that I
use to track serial numbers and each serial number gets put on a test
station that returns data in the following format:

0.0 , 0.0000
0.1 , 0.0995
0.2 , 0.1997
0.3 , 0.3004
0.4 , 0.3999
0.5 , 0.5001
0.6 , 0.5990
0.7 , 0.6991
0.8 , 0.7992

The data is a list of positions and their measurements at that point. I
would like to store this data in a table for each serial number so I can
access it later. Currently our test program outputs this data to a file for
each unit but we ship 1000+ units per week so it is an extraordinary amount
of file to search through.

The current test program is very simple. It sends a "ctrl+S" through the
serial port and received the numbers above. If access could do something
similar it would be a big help for me.

 

[PC Datasheet]

See what you can find here:
http://www.granite.ab.ca/access/serialport.htm


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel