Microsoft Access® is a database application that’s great for storing and organizing data into tables, and creating queries to generate specific reports. If you have a database stored in an Access® file and now want to import them into the Microsoft Excel® spreadsheet, there is a simple function that enables it. In the instructions below, seven simple steps are outlined detailing how to import the data from a “*.mdb” file into the Excel® 2007 or 2010 versions so you can work with them using Excel® functions.
Import Access® data into an Excel® worksheet:
- Open the Excel® application.
- Switch to the “Data” tab on the main ribbon.
- Click on the “Access Data” icon in the “Get External Data“ section.
- Locate the .mdb file on your hard drive and click on the “Open“ button.
- Select the table from the database you want to add to Excel® and double-click it.
- Select how you want to import the data in your workbook (typically, the “Table“ option is selected). Click on the “OK“ button.
- The data from the table are shown in the Excel® worksheet in the same order as the table.