SEARCH

How-To Geek

Import an Access Database into Excel

Sometimes you might need to pull items from an Access database and put them into Excel so you can organize them for a report or presentation. Here we will take a look at how to import the database using Access and Excel 2007.

Import Access Data

Open up a new workbook in Excel and click on the Data tab. Then under Get External Data click on From Access.

1-ax

Browse to the location of the database you want to import.

2-ax

If there are several tables you will need to select the one you want to get the data from.

4-ax

Select how the data will appear in the workbook and choose the cell where you want it to start then click OK.

3-ax

The table data will be place in Excel with the Design tab open so you can organize the look and feel for presenting the data.

5-ax

If you want to get multiple tables into the Workbook, just repeat the above process and import it into new worksheets or different areas on the same worksheet.

6-ax

This process saves a lot of time when going through large amounts of data versus sorting through a report. This should get you started with organizing items from the database however you need it.

Lowell Heddings, better known online as the How-To Geek, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on if you'd like.

  • Published 09/29/09

Comments (1)

  1. calebstein

    This will also work on Excel 2010.

Get Free Articles in Your Inbox!

Join 134,000 newsletter readers

Email:

Go check your email!