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.
Join John Savill for 30 hours of training plus live Q&A and master the complete Microsoft solution stack! All sessions are available on demand the day after the live broadcast, and all sessions will be available on demand until March 2014. Two live classes remain for Semester 1 and Semester 2 begins in January 2014. Click to learn more.
Coming up next....
-- December 5: Hyper-V
-- December 12: System Center 2012 & 2012 R2
-- January 23: Implementing a Private Cloud for Your Organization
Windows Server 2012 R2 provides a huge number of changes and new capabilities to Windows Server 2012. These changes affect not only the datacenter with enhancements to virtualization, storage, and networking but also to the desktop environment and Bring Your Own Device scenarios. This event will dive into some of the more advanced Windows Server 2012 R2 features, help you understand their benefit, and show you how to start implementing.