Get scanner data into database
Hi friends,
I have installed attendance scanner. Daily the employees scans the cards. The scanner s/w will create a text file on the date
Ex: 070105.txt (mmddyy)
It will store the data in the form
cardno time(24 hr format)
We have 400 employees. Daily each person scans min 6 times(in out in out in out)
I want to link this data to my application. How can i get back this data from the text file. I use filesystemobject to read the data. But, i need to get all empID from the database and read associated cardno and loop thru text file and save. For 400 employees it takes long time.
Which way is better. Can anybody suggest any sollution?
Thx in advance
|
