I am not sure what you have here. Please post some sample lines from the file if the data is not sensitive.
It looks like on each line you have three columns, each column ending with .1, .2, .3, and each column delimited by #, =, or !.
What you need to do is read this file one line at a time, then split the line into an array using a delimiting character, or ".", and then open your local table and do something like:
rs("All Row") = ?
rs("text1.x") = st1stVariable
rs("text2.x") = st2ndVariable
rs("text3.x") = st3rdVariable
Looking forward to more info.