Home »  Software »  Office Suite Software

How Do I Import Microsoft Access® Data into Excel® 2007 and 2010

April 17, 2013  |  Difficulty: Medium

import the data from a “*.mdb” file into the Excel®

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:

  1. Open the Excel® application.
  2. Switch to the “Data” tab on the main ribbon.
  3. Click on the “Access Data” icon in the “Get External Data“ section.
  4. Locate the .mdb file on your hard drive and click on the “Open“ button.
  5. Select the table from the database you want to add to Excel® and double-click it.
  6. Select how you want to import the data in your workbook (typically, the “Table“ option is selected). Click on the “OK“ button.
  7. The data from the table are shown in the Excel® worksheet in the same order as the table.

Software:

Most Popular Articles:

What Is the Best Backup Software for Me

Internet Security Solutions Detect Legitimate Soft

How Do I Block Internet Intruders from Spying

How Do I Choose a Data Backup Software

How Do I Install a FREE Spyware and Adware Blocker

Related Articles:

how to convert your Microsoft® Excel® columns to rows with ease.

How Do I Convert Rows to Columns in Excel®

how to set up the universal sorting for any column in Microsoft® Excel® 2010.

How Do I Set Up Universal Sorting in Excel® 2010

how to enhance your next presentation by  creating a pictograph

How Do I Create a Pictograph in Excel® 2010

how to set the password protection on your document in the Microsoft® Excel®

How Do I Password Protect Excel® Files

add background graphics to Excel

How Do I Change the Worksheet Background in Excel®

×
Help Us Spread the Word!

Love us on Facebook to stay updated.

Stay aware and get our best content on health, celebrity, travel, living, career and the technologies that will change the world.