Update MS access table with the data from file

[Asher David]

Hi,

Can anyone help me how to update an MS access table based on the date im reading from my file?

I have table name "PROFILE" and I'm getting the update of it from HTML/TXT file.

The table having 2 columns (NAME, SURNAME). I want to clear all the content of table "PROFILE" before the below codes run.

Let say from HTML:

<name>Asher</name>
<visibility>1</visibility><open>0</open>
<Folder id="1">
<surname>David</surname>
<visibility>1</visibility><open>0</open>
<Placemark>



Now here is my sample code:

Do While Not EOF(1)
    Line Input #1, InputData
    
    If Left(InputData, 6) = "<name>" Then
                 ' Update column "NAME" containing Mid(InputData,10,x)
    End If

    If Left(InputData, 9) = "<surname>" Then
                 ' Update column "SURNAME" containing Mid(InputData,10,x)
    End If

Loop
Close MyReadNum

ANy help? How can I also determin fast the value of x to put in my MID statement? Im doing it in VBA ms access