Page 43 - ModularV1.1 _c8_flipbook
P. 43

Step 13  Click on the Finish button. The Get External Data – Excel Spreadsheet dialog box
                         appears again.
















                                 Import Spreadsheet Wizard-Step 4      Import Spreadsheet Wizard-Step 5
                 Step 14 Click on the Close button. A new table with the name Student Details appears with all
                          the records of the MS Excel file.

















                             Import Spreadsheet Wizard-Step 6                         Imported data
                     EXPORTING DATA FROM MS ACCESS

                 Exporting data means to save the MS Access table data into a different format like PDF or
                 spreadsheet. We can export the data from an MS Access table to different formats like text file,
                 spreadsheet, PDF and e-mail. Follow these steps to export data:

                 Step 1  Open the table that you want to export.
                 Step 2  Click on the desired format from the Export group of the External Data tab. In this case,
                         we have clicked on the PDF or XPS command. The Publish as PDF or XPS dialog box
                         appears.

                 Step 3  Select the location to save the file and type the file name in the File name textbox.
                 Step 4  Click on the Publish button. Your data is exported.















                               Publish as PDF or XPS dialog box                 Exported data

                                                                                  Advanced Features of MS Access   41
   38   39   40   41   42   43   44   45   46   47   48