Question: how to import data from excel into access 2016?
Answer: 1Open the Access database that will hold the imported data. ... 
2Click the External Data tab on the Ribbon. ... 
3Click the button that matches your file format. ... 
4Use the Browse button to select the data source that you want to import or link to Access. ... 
5Select the method of data storage.