Microsoft Access is an important tool for those who want to create and manage databases, and arguably, there is no better tool. But there might come a time when someone wants to export his Access information to Microsoft Excel, so is that possible?
Import the Access database data to Excel
The simple answer is yes, and fortunately there is an easy way to get the job done. We'll use Access and Excel from Microsoft Office 365, so if you're on an earlier version, things might not work the same way.
Open an Excel spreadsheet and:
1. Select menu Data.
2. Next, click Get Data.
3. Select From Database.
4. Click From Microsoft Access Database.
5. Add your Access information to Excel.Import the Access database data to Excel
Let's find out more details about each step!
Select the Data menu
The first thing you want to do here is to make sure the Microsoft Access file is saved on your computer's hard drive. From there, fire up Microsoft Excel and make sure to click on the ribbon with the content Data.
Click From Microsoft Access Database
The next thing to do is to choose where you want your data collected. Since the purpose here is to get data from Microsoft Access, you will be asked to click Get data.
After making that selection go ahead and click From Database> From Microsoft Access Database is placed in the drop-down menu.
Add Access information to Excel
After doing what is shown above, you will see a small window appear in Microsoft Excel. Use it to locate and select your Access file, and as soon as you open it, another window will appear. Make sure to click on one of the panels on the left side of the window, then hit the button below that says something Load.
When done, the information automatically appears in your Excel document. From there, go ahead and save it for future reference.
- Create an input form in Excel, how to create an input form in Excel