Can you give me some sample syntax?

But then how to update table in MS access also?

Should I used like ADO connection something like below?

Code:
Public goCnn As ADODB.Connection
Public oRs As New ADODB.Recordset

oRs.AddNew
On Error Resume Next
      
      If Left(InputData, 6) = "<name>" Then
             oRs.AddNew  
             oRs("name") = Mid(InputData,10,x)
      End If

      If Left(InputData, 9) = "<surname>" Then
              oRs.AddNew
             oRs("surname") =  Mid(InputData,10,x)
      End If



Loop
Close #1  

oRs.Close
goCnn.Close
How to determine the value of x inside my condition:

Code:
If Left(InputData, 6) = "<name>" Then
             oRs.AddNew  
             oRs("name") = Mid(InputData,10,x)

So that I can get the exact value of surname and name?