How to Import MS Access Data into Excel [Example]

In this tutorial, we are going to import data from a simple external database powered by Microsoft Access database. We will import the products table into excel. You can download the Microsoft Access database.

• Open a new workbook
• Click on the DATA tab
• Click on from Access button as shown below

• You will get the dialogue window shown below

How to write a TEST CASE Software Testing Tutorial

• Browse to the database that you downloaded and
• Click on Open button

• Click on OK button
• You will get the following data