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.
If there are several tables you will need to select the one you want to get the data from.
Select how the data will appear in the workbook and choose the cell where you want it to start then click OK.
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.
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.
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.
Programmer by day, geek by night, The Geek, also known as Lowell Heddings, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on Google+ if you'd like.
- Published 09/29/09