G
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.
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.