How to Set Table Relationships in Access 2013
How to Start the Report Wizard in Access 2013
How to Run the Query Wizard in Access 2013

How to Import Data Sources in Access 2013

Follow the remaining steps in the Get External Data dialog box.

From this point forward, the steps depend on which data format you're importing. Follow the prompts carefully. The worst that can happen is that you get an imported (or linked) table full of gibberish. If you do, check the format of the source file.

For example, if the source is a text file and you get gibberish, you may need to confirm that the text file was saved as a delimited file (with a character — a comma, for example — placed between fields). It’s also possible that the source file isn’t in the correct format (for example, you may think it’s an Excel spreadsheet but it’s not).

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
How to Create a Navigation Form in Access 2013
10 Things You Need to Know about Relationships in Access 2013
Getting Help with Functions in Access 2013
How to Convert an Older-Version Access Database to Access 2013
How to Filter Multiple Fields in Access 2013