Question: how to import data from excel in microsoft access 2016?
Answer: In the Get External Data - Excel Spreadsheet dialog box, in the File name box, specify the name of the Excel file that contains the data that you want to import. Click Browse and use the File Open dialog box to locate the file that you want to import. Specify how you want to store the imported data.