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

