One way would be to read the text file line-by-line using the Line Input #(delimited text files) or Input# (looking for EOF). As you receive each line in the text file, write that text, using AddNew, to a new record in a temporary Access database table that you have previously created. That temporary table should contain just one field. Then, when you have finished reading the entire text file (reached EOF), go thru that temporary database table, retrieve each record, parse the line (using MID$) storing the text values in variables that will be placed in your target table.
You might could also skip the temporary table part, parse the text string being read from the text file, and place that data directly into your target table. I haven't tried this last approach, but I have used the first approach many times. Good luck!