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.
Past Sessions Available for Instant Access! Semester 2: January 22nd to February 19th Access to Recordings through May 20, 2015
John Savill will cover topics including:
* Deploying, Managing, and Maintaining Windows * Key Features of Active Directory from Windows 2000 to Windows Server 2012 * Key elements of System Center 2012 and System Center 2012 R2 * Deploying, Migrating to and Managing Hyper-V in Your Organization * Implementing a Private Cloud * Using PowerShell to Automate Common Tasks * PLUS a preview of Windows 10