Try the Access Course for Free!

Export Data from Access – Tutorial

/ / Access 2013, Access 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
Export Data from Access - Tutorial: A picture of a user exporting table data to a text file in Access 2016.

Export Data from Access: Overview

            You can easily export data from Access to a wide variety of formats that are available. You can also export other database objects, like forms and reports. However, there are more limitations on the formats to which you can export these types of objects.

            To export data from Access, first select the table or other database object to export in the Navigation Pane. Next, click the “External Data” tab in the Ribbon. In the “Export” group, click the button for the file format to which you want to export the selected object.

Export Data from Access - Tutorial: A picture of a user exporting table data to a text file in Access 2016.

Export Data from Access – Tutorial: A picture of a user exporting table data to a text file in Access 2016.

            Doing this then opens the “Export” wizard for the type of export you selected. The specific steps shown in each wizard will vary slightly, depending on the file type to which you are exporting. Most of the time, you must select a name and file location for the exported object. You will also often need to set additional parameters for the export routine. Just as when you import data, you will also be prompted to save your export routine, if desired.

Export Data from Access: Instructions

  1. To export data from Access, first select the table or other database object to export in the Navigation Pane.
  2. Click the “External Data” tab in the Ribbon.
  3. Click the button in the “Export” button group for the file format to which you want to export the object.
  4. Doing this then opens the “Export” wizard for the type of export you want to perform.
  5. The specific steps shown in each wizard will vary slightly, depending on the file type to which you are exporting. Most of the time, you must select a name and file location for the exported object. You also often need to set additional parameters for the export routine.
  6. You will also be prompted to save your export routine, if desired.

Export Data from Access: Video Lesson

            The following video lesson, titled “Exporting Data,” shows you how to export data from Access. This video on how to export data from Access is from our complete Access training, titled “Mastering Access Made East v.2016-2013.”

TOP
Extra 30% Off Store-Wide 0 Days 4 Hours 50 Minutes 18 Seconds      Use Coupon: EXTRA30
Shop Now