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.

Brian Burgess worked in IT for 10 years before pursuing his passion for writing. He's been a tech blogger and journalist for the past seven years, and can be found on his about me page or Google+

  • Published 09/29/09

Comments (1)

  1. calebstein

    This will also work on Excel 2010.

Enter Your Email Here to Get Access for Free:

Go check your email!