Import Excel Spreadsheet into Access
Channel: LearnAccessByCrystal
Date: 2019-03-27

Import data from Excel into a Microsoft Access database using the Excel icon on the External data ribbon tab. Why it a good idea to reconsider data type if Double precision will be used, especially for whole numbers.

Add a field to the table with imported data, and fill it in using an Update query.

Create a calculated field using the DateSerial function to construct a date from numeric year, month, and day values.

Also learn how to get the full path and filename of the active workbook in Excel.

To loop through all sheets of a workbook and combine them in Access, here is code you can use:
http://msaccessgurus.com/VBA/Code/aExcel_ImportWorksheets_AppendTable.htm

free code you can use in your projects
https://msaccessgurus.com/code.htm