I would import this whole data string into a field in a staging table. Then, in the OnClick event of button, I would run some code to read a record from the staging table, parse it and then store it in your separate fields of your data table. I am assuming that the TX is Texas and that PORTER is the city. If I am wrong, you should still be able to get the idea. To parse it, it should be something like:
Public Function ParseDL()
Dim db As Database
Dim rst1 As Recordset
Dim rst2 As Recordset
Dim WholeRecord As String
Dim LicState As String
Dim LicCity As String
Dim LName As String
Dim FName As String
Dim MName As String
Dim Address1 As String
Dim pos As Integer
Set db = CurrentDb
Set rst1 = db.OpenRecordset("select * from tblStaging"

Set rst2 = db.OpenRecordset("select * from tblDL"
rst1.MoveFirst
Do While Not rst1.EOF
rst1.Edit
rst2.AddNew
WholeRecord = rst1!DLInfo
pos = 2
rst2!LicState = MID(WholeRecord, pos, 2)
pos = 4
rst2!LicCity = MID(WholeRecord, pos, INSTR(1, WholeRecord, "^"

- 1)
pos = INSTR(1, WholeRecord, "^"

+ 1
rst2!LName = MID(WholeRecord, pos, INSTR(pos, WholeRecord, "$"

- 1)
pos = INSTR(pos, WholeRecord, "$"

+ 1
... *** Continue parsing different fields here. You should have the idea by now... ***
rst2.Update
rst1.MoveNext
Loop
rst1.Close
rst2.Close
db.Close
End Function
I didn't test any of this, and all of the table/field names will need to be changed to your names...
Hope that helps... Terry M. Hoey