Microsoft Access is the primary tool for those who want to create and manage a database, and arguably, there is none better. Now, there may come a time when a person might want to export their Access information to Microsoft Excel, so is that possible?
Import data from Access Data Database into Excel
The simple answer to that is a resounding yes, and we will discuss how to get the job done in the best and easiest way. Remember that we are using Access and Excel from Microsoft Office 365, so if you’re using an older version, things might not work the same way. So open an Excel spreadsheet and:
- Select the Data menu
- Next, click on Get Data
- Select From Database
- Click on From Microsoft Access Database
- Add your Access information to Excel.
Let us talk about this from a more detailed perspective.
Select the Data menu
The first thing you will want to do is make sure your Microsoft Access file is saved on your computer’s hard drive. Then, fire up Microsoft Excel and be sure to click on the section of the Ribbon that says Data.
You must click on Data and nothing else, so keep that in mind before moving forward.
Click on From Microsoft Access Database
OK, so the next thing you want to do here is select where you want to collect your data. Since we’re talking about Microsoft Access, you must click on the Get data as shown in the image above.
After making that selection, please click on From Database, then From Microsoft Access Database, located via the dropdown menu.
Add your Access information to Excel
Once you’ve done what we’ve outlined above, you should see a small window within Microsoft Excel. Use it to locate and select your Access file. Right away after opening, another window will pop up. Be sure to click on one of the tables on the left side of the window, then hit the button below that says Load.
When that is done, the information should automatically appear in your Excel document. Then, you can save it for future reference.
Read: Microsoft Access Features, Tips and How-To for beginners.
Leave a Reply