How to copy Excel sheet into Access

This tutorial details how to copy a sheet from Excel in Access


In this tutorial you are going to learn how to copy excel sheet into access, which can save you a lot time entering data.

Step # 1 – Finding the Excel Data Import Icon

Start Access and load the database into which you want to import the data. In this example we are importing the data into a new database. In the ribbon menu click on “External Data” and you will see there is a special icon for importing data from Excel, click on this icon.

The dedicated Excel import button

Step # 2 – Importing the Data

The “Get External Data” window will open and you need to click on the “Browse” button and locate the Excel file with the data you want to import and click “Open” and then click “OK”. You’ll be taken through a few screens, click “Next” four times, then “Finish”, finally click “Close”.

Finishing the data import

Step # 3 – Viewing the Imported Data

This is essentially how to copy excel sheet into accessand to view the imported data you need to navigate to “Sheet1” in the left hand menu as this is where you will find the imported data.

The successfully imported data in Sheet1