Exporting Data from Access to Excel

Microsoft Access is a Relational Database Management System(RDMS).which can organise information entity wise and provide efficient retrieval with the help of queries.

In this article, we will practice how to export data from Access to Excel. For that,we downloaded some dummy data from generatedata website.The dummy data has the following fields Name, Email, Company, OrganisationNumber, Phonenumber

Importing Data from Access to Excel
Employee Data

In the Ribbon,you can click External Tab and then click Excel under Export group. ( Don’t confuse with Excel under Import group. this option is for importing data from Excel to Access).

Now, It will open the Excel export wizard,and select the required options as per below image to export the data.

Exporting Data to Excel form Acess
Export Dialog to Excel

Finally, you will see a wizard confirming whether you want to save your export steps.

When to use Save Exports :

A simple case study to explain the save exports scenario. For suppose,If you are working as an analyst and handling Operational database which includes data regarding business activities.every day , if you want to forward the category wise data in the operational database to concerned manager.

write a query against the operational database as per the requirements from the concerned manager. and then,save export steps option. which will automate your exports by running macros.

Note :

    If you want to export data to existing workbook.please close the preferred workbook and then run the above steps. the name of workbook should be the name of the Access table or Query.

Leave a Reply

Your email address will not be published. Required fields are marked *