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.

Take our Introduction to Microsoft Access 2016 course for free.

See the Course Outline and Register

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.

Webucator provides instructor-led training to students throughout the US and Canada. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP.NET, Microsoft Office, XML, Windows, Java, Adobe, HTML5, JavaScript, Angular, and much more. Check out our complete course catalog.

Categories

Courses

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