How to Import Excel Into Access
                     How to Import Excel Into 
Access
How to Import Excel Into 
Access
How to Import Excel Into 
1. Open the Access programA ocn cyoeurs csomputer
Go to the start menu, choose MS Office, and click on MS Access. You need to open a new 
blank Access database to import the Excel sheet into it.
• Choose "blank desktop database" to create a new database within the Access program.
• Give it a new name if you want. Click "create."
How to Import Excel Into 
Access
2. Import an Excel spreadsheet into Access
The next step is to pull the Excel spreadsheet (or more than one) into the Access database.
• Click on "External Data" in the toolbar once you are within the Access database manager. 
Choose "Excel.“ In some versions of Access, you will find this function by clicking on "file" 
in the toolbar and "Get External Data."
• Where it says "file name," click "browse." This will allow you to find your Excel sheet on 
your computer.
• Leave the box checked that says "import the source data into a new table in the current 
database." It will be checked by default.
• When you find the Excel spreadsheet you want to import on your computer, click on it. 
Click "OK." This will take you into the wizard for importing Excel into Access.
For more detail click here: office setup