Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
How to Set Table Relationships in Access 2013
How to Create a Navigation Form in Access 2013
How to Run the Query Wizard in Access 2013

How to Import Data Sources in Access 2013

Step 1 of 6
Previous
Next Slideshow
Next Slideshow

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.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
10 Things You Need to Know about Relationships in Access 2013
How to Start the Report Wizard in Access 2013
How to Filter Multiple Fields in Access 2013
How to Convert an Older-Version Access Database to Access 2013
How to Keep Blank Pages Out of Your Access 2013 Report
Advertisement