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

[Hack]

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

Then I would run an SQL DELETE query...that will remove all records from your table with just one statement.

[Asher David]

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?

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:

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?