Access and Excel are Microsoft apps, so their dataset can be compatible. Sometimes, you may need to transfer your Access data to Excel. This may sound like a hard task for new users, but it is not. This article covered you if you need to learn how to export Access data to Excel. Let us now discuss some of the common methods that can be used to transfer Access data to Excel.
Using the Get External Data Tool
Steps to follow:
1. Open the Excel application and document hosting the Access data.
2. On the Ribbon section, click on the Data tab.
3. Then, locate the Get External Data section, and click the From Access button.
4. A select Data source dialogue box will open. From the dialogue box, choose the File that contains the Access data.
5. Hit the Open button to add the File to your Excel document.
Using New Query Tool
Steps to follow:
1. Open the Excel application and document hosting the Access data.
2. On the Ribbon section, click on the Data tab.
3. Locate the Get & Transform section, and click on the New Query drop-down button.
4. From the menu, hover the cursor over the From Database button. Choose the From Microsoft Access Database option by clicking on it.
5. An Import Data dialogue box will open. From the dialogue box, choose the File that contains the Access data.
6. Hit the Open button to add the File to your Excel document.
Using Export Tool in Microsoft Access
A] Exporting with Data Formatting
Steps to follow:
1. Open the Access document that contains the data you wish to transfer.
2. On the Ribbon section, click on the External Data tab.
3. Locate the Export section, and click on the Excel button.
4. An Export dialogue box will open. From the dialogue box, locate the File name section, and click the Browse button to add the name of the Exported document.
5. In the File Format drop-down menu, choose the Excel Format.
6. Then, check the “Export data with formatting and layout” checkbox. Finally, hit the OK button.
B] Exporting without Data Formatting
Steps to follow:
1. Open the Access document that contains the data you wish to transfer.
2. On the Ribbon section, click on the External Data tab.
3. Locate the Export section, and click on the Excel button.
4. An Export dialogue box will open. From the dialogue box, locate the File name section, and click the Browse button to add the name of the Exported document.
5. In the File Format drop-down menu, choose the Excel Format.
1. Then, uncheck the “Export data with formatting and layout” checkbox. Finally, hit the OK button.