- Open a new workbook, or an existing one and select a worksheet.
- On the Data tab, Get External Data group click From Access.
- The Select Data Source window will open. Select the Access database file and click Open.
- The Select Table window will open. Select the table you want to import and click OK.
- The Import Data window will open. Specify how you want to view the data and whether you want it in the existing worksheet or a new one. Click OK.
- Here is how your data will look like in Excel:

















