Microsoft Office Tutorials and References
In Depth Information
Importing Data from an Excel Worksheet
First Import Spreadsheet Wizard dialog box
selected check box
confirms that the
first row c ontains
data from the
worksheet to be
The dialog box confirms that the first row of the worksheet you are importing
contains column headings. The bottom section of the dialog box displays some of the
data contained in the worksheet.
10. Click the Next button. The second, and final, Import Spreadsheet Wizard dialog
box opens. Notice that the Import to Table box shows that the data from the
spreadsheet will be imported into the Invoice table.
11. Click the Finish button. A dialog box opens asking if you want to save the import
steps. If you needed to repeat this same import procedure many times, it would
be a good idea to save the steps for the procedure. However, you don’t need to
save these steps because you’ll be importing the data only one time. Once the
data is in the Invoice table, Oren will no longer use Excel to track invoice data.
12. Click the Close button in the dialog box to close it without saving the steps.
The data from the Invoices worksheet has been added to the Invoice table. Next,
you’ll open the table to view the new records.
To open the Invoice table and view the imported data:
1. Open the Navigation Pane, and then double-click Invoice in the Tables section to
open the table in Datasheet view.
2. Resize the Invoice Item column so that all field values are fully displayed, being
sure to scroll down through the entire datasheet and repeat the resizing as
necessary. When you resize a column by double-clicking the pointer on the column
dividing line, you are sizing the column to its best fit —that is, so the column is just wide
enough to display the longest visible value in the column, including the field name.