natchaya khamkuna

natchaya khamkuna

  • NA
  • 31
  • 23.2k

Please teach me how to handle the text file ( clock in-out )

Jun 3 2011 11:11 AM
ID DD MM YYYY Hour : Minute (In/Out)
0000042003 27 08 2008 09 38 I
0000042003270820080938I
0000042003270820080939O


The data above I got from  swipe card time machine for employee clock in-out .

How can I  import to  database  ( I expect to use the sql server 2008 )

and how to the table should be.

 Programmer please teach me please.


Answers (6)