Question: how do you import data into access?
Answer: Open the Access database that will hold the imported data and click the External Data tab on the Ribbon. ...  Click the button that matches your file format. ...  Select the data source that you want to import or link to Access. ...  Select the method of data storage.