From the course: Office 365: Access Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Exporting tables to Excel

Exporting tables to Excel - Microsoft Access Tutorial

From the course: Office 365: Access Essential Training

Start my 1-month free trial

Exporting tables to Excel

“

There will be times when you want to move your data out of Access in order to perform some further analysis with the tools available in Excel. In order to do that, we need to export our data to an Excel file. First, we need to select the object that we want to export. In this case, I'm going to use the MonthlyRevenueSummary that's here on my Navigation pane. Let's go ahead and double-click on it to open it up. If I want to export just a selection of records, we can make a selection here before we start the Export Wizard. For instance, I'll click on this record here and then shift-click down here, and that will select just these records here. I want to export the entire table though, so I'm actually just going to close it down. And make sure that it stays selected over here in the Navigation pane. Just like all of the export tools, we can find them on the External Data tab in the Export section, and I'm going to press the Excel button here. That will start up the Export Excel…

Contents