Question: how to import data from excel in access?
Answer: Open the Access database. If you receive a security warning, click the Enable Content button. On the Office ribbon, select the External Data tab and click Excel. The "Get External Data - Excel Spreadsheet" wizard appears. ...  Select the worksheet to import.