I have a text file that I am trying to importing into an Access database. The text does follow a structure dut not the best for placing it a table . I have attached an example of what the current text file looks like.
I am trying to get the contents in the text file into a table that has three columns: Student_NM - Student_Major - Student_Class
Is there a way to do this using either VBA or a cmd file that could at least format the data and dump it back into another text file but deliminated?
Any assistance with this would be much appreciated.