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
   37   38   39   40   41   42   43   44   45   46   47