After clicking the Get Data button on the Data tab, what do you select to import an Access database table into Excel?
A) Point to From Database and then click From Microsoft Access Database.
B) Click Import and then click Access.
C) Click Access Database Wizard.
D) Click Navigate and then click Microsoft Access.

Question

Quizplus · Accepted Answer

The correct option is to point to From Database and then click From Microsoft Access Database. This will launch the Microsoft Query wizard, which will guide you through the process of choosing the Access database and the table you want to import into Excel.

After Clicking the Get Data Button on the Data Tab