Page 42 - ModularV1.1 _c8_flipbook
P. 42
Step 4 Click on the Open button. The name and location of the selected file appears in the File
name text box in the Get External Data - Excel Spreadsheet dialog box.
Step 5 Click on the OK button. The Import
Spreadsheet Wizard appears that displays
all the worksheets from the selected workbook
and the data of the Sheet 1.
Get External Data - Excel Spreadsheet dialog box
Step 6 Click on the Next button. The next step
appears asking to make the first row as
column headings.
Import Spreadsheet Wizard-Step 1
Step 7 Select the First Row Contains Column
Heading checkbox, if not selected. Ensure
that the selected MS Excel file contains the
row headings in the first row.
Step 8 Click on the Next button. The next step
appears asking you to specify the
information about each of the fields you
are importing.
Import Spreadsheet Wizard-Step 2
Step 9 Make the desired changes and click on the
Next button. The next step appears asking
you to define a primary key.
Step 10 Select any one option out of the three
options—Let Access add primary key,
Choose my own primary key and No
primary key. In this case, we have selected
the Let Access add primary key option.
Step 11 Click on the Next button. The next step
appears asking you to enter the table name Import Spreadsheet Wizard-Step 3
in which you want to import the data.
Step 12 Type the table name in the Import to Table textbox. In this case, we have typed the
Student Details.
40 Modular (Ver. 1.1)-VIII

