Access+importing+from+excel

Home / software / microsoft access / Tutorials

> Notice a spreadsheet named Employees > > > > > >
 * Practical Learning: Importing a Microsoft Excel Spreadsheet ||
 * 1) From the resources that accompany these lessons, open the Clarksville Ice Cream.xlsx file.
 * 1) From the resources that accompany these lessons, open the Clarksville Ice Cream.xlsx file.
 * 1) Select cells from C5 to F10
 * 2) On the Ribbon, click Home and, in the Clipboard section, click Copy
 * 3) Return to Microsoft Access and click the Home tab on the Ribbon
 * 4) On the table, right-click the intersection of the column headers and row header [[image:http://www.functionx.com/access/buttons/interrulers1.gif width="22" height="23" caption="Intersection"]] in the Clipboard section of the Home tab of the Ribbon, click the Paste button
 * 1) When you receive a message box letting you know that a few records would be created, click Yes
 * 2) Double-click ID, type **EmployeeID** and press Enter
 * 3) To save the table, on the title bar, click the Save button
 * 4) Type **Employees** as the name of the new table and click OK
 * 5) Close the table
 * Whether you have Microsoft Office Excel 2010 or not, continue the lesson here**
 * 1) On the Ribbon, click External Data
 * 2) In the Import & Link section, click Excel [[image:http://www.functionx.com/access/buttons/excel1.gif width="42" height="66"]]
 * 3) In the Get External Data - Excel Spreadsheet, click Browse...
 * 4) Locate the folder that contains the resources for our lessons and select it
 * 5) Select the Clarksville Ice Cream.xlsx file and click Open
 * 6) In the Get External Data - Excel Spreadsheet, click OK
 * 7) In the first page of the wizard, click the Show Named Ranges radio button and, in the list, click PayrollInformation
 * 1) Click Next
 * 2) In the second page of the wizard, click the **First Row Contains Column Headings** check box
 * 1) Click Next
 * 2) In the third page of the wizard, accept all defaults and click Next
 * 3) In the fourth page of the wizard, accept all defaults and click Next
 * 4) Set the name of the table to **Payroll** and click Finish
 * 5) In the last page of the wizard, click Close
 * 6) In the Navigation Pane, double-click the Payroll table to open it
 * 7) Double-click ID, type **PayrollID** and press Enter
 * 8) Close the Payroll table