Microsoft Access is an efficient program for creating and maintaining databases. You can use Excel spreadsheets to manipulate and assess the data that is kept in an Access table. Microsoft has made it simple for the Office applications to collaborate with each other to do various things. Exporting your data from Microsoft Access to be analyzed in Excel takes only a few minutes.

Step 1

Open the database that contains the data you want to export in Access. Click on “File,” then “Open” if you are using Access 2003 or earlier. Click on the “Office” button and then “Open” in Access 2007.

Step 2

Choose what you want to export. You can open the table to export certain rows of data or export the entire table. To export just some of the data in the table, double-click the table to open it and then highlight the rows you want. To export the entire table, click it once in the Objects window.

Step 3

Export the data to Excel. Click on “File,” then “Export” if you are using Microsoft Access 2003 or earlier. The “Export” dialog box appears. Click the drop-down box next to “Save as type.” Choose one of the Excel formats (depending on your version of Excel). Click the check box next to “Save formatted.” Click “Save Selection” if you selected certain rows within the table. Click “Export All” if you want to export the entire table. For Access 2007, click on the “External Data” tab in the ribbon. Click “Excel” under the “Export” section. Follow the wizard to export the data you want to an Excel file.

Most Access users will, at some point, need to export their Access database to an Excel spreadsheet. OK, most users don’t need to export the whole Access database – they will usually only need to export a table or the results of a query to Excel. Once in Excel, they can use the data as they would normally use data in Excel.

Excel isn’t the only format that you might want to export data to. You might want to export from Access to XML, HTML, CSV file, or even a PDF file. Fortunately you can do all of these in Access 2013.