How to Export a Recordset from Microsoft Access to Excel

  • google plus

In Brief...

Once you have the perfect recordset, you may wish to print, save as a PDF, or export the recordset out to another format. The following steps show how to export a recordset from Access to Excel.

This feature works the same in all modern versions of Microsoft Access: 2010, 2013, and 2016.

Instructions

  1. Choose External Data > Export > Excel to open the export wizard.
    Open Export Wizard

  2. Choose a location and then click OK.
    Choose Location

  3. Your recordset data has now been saved as an Excel spreadsheet.

Author: Tracy Berry

Tracy has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide, including involvement in large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, reporting/productivity applications, as well as the creation of online courses with software from leading vendors.

Discuss