Question: how to import data from excel into access table?
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.