Dear All,

I have problem reading data from *.dat format. Anyone can help appreciated. Example:

I have lines of data in my "Attendance.dat":

03321741!20060126!0!115732!06!
03323192!20060126!0!115734!06!
03322484!20060126!0!115736!06!
03322657!20060126!0!115739!06!
03322536!20060126!0!115758!06!
03322405!20060126!0!115801!06!
03323177!20060126!0!115803!06!
03323175!20060126!0!115806!06!
03322510!20060126!0!115827!06!
03322474!20060126!0!115830!06!
03323143!20060126!0!115903!06!

How can i select only a known data (ex: "03323177") field from the "Attendance.dat" and transfer it to a Table in database (Access Database, or SQL server table)?

Please help,

Thank you in advance.

Morith