How to Import Data Sources in Access 2013
1 of 6
Open the Access database that will hold the imported data and click the External Data tab on the Ribbon.
The Import & Link group of buttons appears on the Ribbon.
Each button is connected to a wizard that walks you through the process: Common file formats such as Excel or Text (labeled as Text File) have their own specific buttons; you can find the less common file formats using the More button.