Hi Mike,
Without a sample I cannot fully help you. However, here is how to loop through every file in a folder:
Where the code has Path = you need to put the location of the folder
Where the code has YOUR CODE HERE is where you need to add in code to copy the data from the open file to your database

Sub Update()
    Dim Path As String, StrFile As String
    Path = "C:\Temp\" 'Whatever your folder path is
    StrFile = Dir(Path & "*")
    Do While Len(StrFile) > 0
        Workbooks.Open(Path & StrFile).Activate
        ' YOUR CODE HERE
        ActiveWorkbook.Close SaveChanges:=True
        StrFile = Dir
    Loop
End Sub