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.

Get External Data From Access

2. Select the Access file.

Select Access File

3. Click Open.

4. Select a table and click OK.

Select Table

5. Select how you want to view this data, where you want to put it, and click OK.

Import Data

Result. Your database records in Excel.

Data in Excel

Note: when your Access data changes, you can click Refresh to update the data in Excel.

Did you find this information helpful? Please vote for us.

Go to Top: Import Access Data    |    Go to Next Example: Microsoft Query

Go back to workbook, Go to the right >>