Import (or link) Excel data into Access

Name the range in Excel that stores your data. Consider using a dynamic-named range or the DynaTable to store your data.
Start a blank Access database and go to the Tables 'tab' of the database.
Click the
New button and double-click
Import Table.
- You can also choose to Link Table if you want the data stored in Excel to be the authoritative source of data.
The Wizard will step you through the process.
- When you are asked to find the database—you may not even see it unless you choose the appropriate file type from the Files of type drop-down list.
- Pay attention to each step and follow instructions carefully. The only potential trick is when you are asked to set a primary key. The default is that Access will create a primary key for you. If your data has a natural key, select it instead.