To import an Excel spreadsheet into a new table in Access:
  1. Open the Access database.
  2. If you receive a security warning, click the Enable Content button.
  3. On the Office ribbon, select the External Data tab and click Excel.

     
  4. The "Get External Data - Excel Spreadsheet" wizard appears. In the File name field, browse to the Excel file. Select the "Import the source data into a new table in the current database" option and click OK.
  5. Select the worksheet to import. Click Next.
  6. If the first row contains headers, mark the "First Row Contains Column Headings" checkbox. Click Next.
  7. Select the options for each column or just leave it at the default and click Next.
  8. Accept the default of "Let Access add primary key." Click Next.
  9. The Import to Table field defaults to the worksheet name. Update it if needed. Click Finish. The worksheet imports into a table.
To import an Excel spreadsheet into an existing table in Access:
  1. Ensure that the spreadsheet uses the exact headers as the existing Access database.
  2. Open the Access database.
  3. If you receive a security warning, click the Enable Content button.
  4. On the Office ribbon, select the External Data tab and click Excel.

     
  5. The "Get External Data - Excel Spreadsheet" wizard appears. In the File name field, browse to the Excel file. Select the "Append a copy of records to the table" option. In the drop-down, select the appropriate table and click OK.
  6. Select the worksheet to import. Click Next.
  7. Click Finish.