Help!! Insert into a table using VB

I want to write/insert the value of foundFiles into a table.

How can i paste a value into a table using VB??
Can someone help?


I want to get "FoundFiles(i)" and paste it into a table

Set fs = Application.FileSearch
With fs
    .LookIn = "C:\My Documents"
    .FileType = msoFileTypeBinders
    If .Execute > 0 Then
        MsgBox "There were " & .FoundFiles.Count & _
            " Binder file(s) found."
        For i = 1 To .FoundFiles.Count
            MsgBox .FoundFiles(i)
        Next i
    Else
        MsgBox "There were no Binder files found."
    End If
End With



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!