O'Reilly logo

Microsoft® Office® Professional 2013 Plain & Simple by Katherine Murray

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing data

If you’ve been collecting data in other places—perhaps in a text file or an Excel spreadsheet—you can easily import your data into Access 2013 so that you don’t have to type it all again. You use the External Data tab to bring that information into your desktop database.

Import data

  1. Click the External Data tab.

  2. In the Import & Link group, click Access.

    The Get External Database dialog box opens.

  3. Click the Browse button. In the File Open dialog box, navigate to the file that you want to open, click it, and then select Open. The file name is added to the Get External Data dialog box.

  4. Leave the Import Tables option selected.

  5. Click OK.

    The Import Objects dialog box opens.

  6. Click Select All. Alternatively, select the name of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required