title: import excel file into access table
body: <p>I am creating an Access database and some help with VBA would be much appreciated.</p>
  
  <p>Help is what I need to do,</p>
  
  <p>I have an Excel worksheet containing data that needs to be added to the existing table in Access. Is there a way in VBA to add the data in excel row by row?</p>
  
  <p>For every row in Excel I need to:</p>
  
  <p><strong>1st</strong>: check if the sample_number already exist in Access table, then do some action if it exist.</p>
  
  <p><strong>2nd</strong>: if the sample_number doesn't already exist then copy and paste this row from excel to Access table.</p>
  
  <p>Right now I am stuck on how to process the excel spreadsheet row by row rather than importing the whole sheet at once.</p>
  
  <p>Helps are much appreciated!
  Thanks</p>