Access 2016 For Dummies
Book image
Explore Book Buy On Amazon

Access 2016 gives you the ability to upload a data table from an existing source such as an Access desktop database, an Excel spreadsheet, or text file. Follow these steps to upload an existing Access table. Steps for other file formats are similar.

  1. Click Table from the Create group on the Home tab of the Ribbon if necessary.

  2. Click Access from the Create a table from an existing data source list.

    The Get External Data dialog box appears, ready to serve.

    Select the source of the existing table.
    Select the source of the existing table.
  3. Click Browse, navigate to the file location, and then click on the file that contains your table.

  4. Click Open.

    The path and file name are entered in the File name text box in the Get External Data dialog box.

  5. Click OK.

    The Import Objects dialog box appears.

  6. Select the table name and click OK.

    The table and its data are imported into the web app.

  7. Click Close.

    The imported table appears down the left side of the web app screen.

Web app tables are maintained just like Access desktop database tables. Just open the Navigation Pane (F11), right-click the table, and choose Design View.

About This Article

This article is from the book:

About the book authors:

Laurie Ulrich Fuller is a professional technology author and trainer. She's created training materials that cover Microsoft Office and Adobe Creative Suite. Ken Cook is a professional database developer, instructor, and author. The two experts have teamed to write the previous three editions of Access For Dummies.

This article can be found in the category: