I have a text file that needs to be exported to a sql server table. the text file is something similar to this,
06:00 go to work
17:00 go home
21:00 go to bed
09:00 go to leisure centre
I need to pull these details to a db table which has columns Date, Time, Description. The first record imported will be Date. A new record begins when a new time delimiter appears in the text file. A new date begins if a record falls after 06:00.
Does anyone have idea how to do this using vb.net?