Microsoft Office Tutorials and References
In Depth Information
Choosing the data type for each field in the Import Spreadsheet Wizard
that is, define a
primary key. Because you will store your data in a new table, choose your own primary key (Employee ID),
as shown in Figure B-76.
Choose Next. In the next screen of the wizard, you will be prompted to create an index
Choosing a primary key field in the Import Spreadsheet Wizard
Continue through the wizard, giving your table an appropriate name. After importing the table, take a
look at its design by highlighting the Table option and clicking the Design button. Note that each field is very
wide. Adjust the field properties as needed.