Hi, I am looking for advise to store data from a scanner in an access table.
The scanner is connected to a USB port. If the active window is the windows notepad, what you scan with the scanner appears on screen with a return (cursor moves to next line). Multiple scans provide a list of scanned data.
We have a bicicle race where each competitor gets a card to put in his/her byke with plastic ties. The card contains a number (ie 1000) and a small barcode with same number (ie 1000). The intent is to scan the card on arrival to finish line and store the scanned number along with a time stamp (date/time) to a table containing those 2 columns (number, timestamp).
The same database would contain another table with the participants info (name, address, town, category, etc) including the card number assigned. We can join both tables on the number column to get queries of when a participant arrived, which place, by category, how long it took to finish, etc.
Any suggestions on the best way to grab & store the scanned data?
Thanks for the assistance.
Tidak ada komentar:
Posting Komentar