Hi,
I have a text file that needs to be exported to a sql server table. the text file is something similar to this,
-------------
01.08.2007
06:00 go to work
12:00 lunch
17:00 go home
19:00 dinner
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?