Hello everyone,
I have a form with a button. When this button is pressed I want it to update a table in my database. I don't want to use the wizard to accomplish this, but only VBA. I have it now to where it will add a new table when the button is clicked. I just need it to update an already existing table with the data from the Excel document.
So for the button i have right now is this
Private Sub Command0_Click()
Dim filepath As String
Dim User As String
User = Environ("username")
filepath = "C:\Users\" & User & "\Downloads\Borrower.xlsx"
DoCmd.TransferSpreadsheet acImport, , "Borrower_Import", filepath, True
End Sub
The table I am trying to update is "Borrower"
Any information you can provide is greatly appreciated!