title: Import new data into existing table access vba
body: <p>Currently I can input excel data into new tables, but I would like to append the new data to the table everytime I select a new excel sheet? The code I am using now is shown below. </p>
  
  <pre><code>Option Compare Database
  Option Explicit
  
  Public Sub ImportExcelSpreadsheet(fileName As String, tableName As String)
  On Error GoTo BadFormat
      DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "Sample", 
  fileName, True
  
  Exit Sub
  </code></pre>