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.