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

September 29, 2009 · 1 min · 72 words · Sandra Fowler

Then under Get External Data punch From Access.

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

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

Import an Access Database into Excel

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.

2-ax

4-ax

3-ax

5-ax

6-ax