Access 2016: Export Data from Microsoft Access
You can export data from Access to a variety of formats by using the External Data tab on the Ribbon.
Access 2016 includes options for exporting data to other sources. You can export to a variety of formats, including:
- Excel file
- Text file (CSV, TSV, etc)
- XML file
- PDF file
- XPS file
- Word document
- Sharepoint list
- HTML document
- Another Access database
- ODBC datasource (such as SQL Server)
You can export from a table, a query, a form, or a report.
Today we'll export two different queries to two different formats:
- We'll export our Iron Maiden Albums query to an Excel spreadsheet.
- We'll export our Albums from the last 25 years query to an XML file.
Export a Query to Excel
Let's export the results of the Iron Maiden Albums query that we saved previously.
In this case, we'll export the query results to an Excel spreadsheet.
Export to an XML File
Now we'll export our Albums from the last 25 Years query (that we built with the Expression Builder) to an XML file.
Review the File/s
Navigate to the location you chose for the files and open them.