Import Access Data
This example teaches you how to import data from a Microsoft Access database. In Excel, when you import data, you make a permanent connection that can be refreshed.
1. On the Data tab, in the Get External Data group, click From Access.
2. Select the Access file.
3. Click Open.
4. Select a table and click OK.
5. Select how you want to view this data, where you want to put it, and click OK.
Result. Your database records in Excel.
Note: when your Access data changes, you can click Refresh to update the data in Excel.