How to Import Data Sources in Access 2013

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.