If you need to import an Access database into Excel, there are a few different ways to do it. The easiest way is to use the Import Wizard. You can also use the Export Wizard to export the data into a comma-separated value (CSV) file. Finally, you can use the Import Data command in Excel’s File menu. ..
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.
