how do you get data from an MS access table in Excel?
Answers
Answered by
1
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.
Similar questions