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. 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.