The accepted answer to
this post[
^] gives an excellent tutorial on loading text files of this nature into SQL Server using SSIS.
If you are not able to use SQL Server (or only have access to the Express versions) then you will probably need to write a program to first read the file, split the lines up and store to whichever database you have. Exactly how to do this will depend on which database you decide to use, and which programming language to pick / are familiar with. Whichever combination you choose there are bound to be articles here on Code Project that will help you.
If you choose to use MS Access (I wouldn't) then you could do this in VBA (I don't recommend this). Again you can google for examples to help you along.