I need to transfer data from text file to Data base(Access)
My data stored in following format in text file.
18:00-19:00 0 0 0:00 0 0:00 0:00 0 0 0 The program uses Mid function to put data into the variable and then transfer into the database. For example,
xDatetime=Mid(Textline,1,2) and then !Datetime=xDtaetime
Does anybody know, how can I do it differently?