Question: how to import and transform access database data into excel?
Answer: On the Data tab, in the Get & Transform Data group, click Get Data.
Click From Database, From Microsoft Access Database.
Select the Access file.
Click Import.
Select a table on the left side of the Navigator window and click Load. Result. ... 
When your Access data changes, you can easily refresh the data in Excel.