MS Access 2007 Step By Step - Asim Abbasi
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Chapter 6: MS Access Data Import/Export Feature
Step 6: Write Name for Table & Click Finish
Figure 6-14: Assign name to the new table.
________________________________________
1. Finally the ‘Import Spreadsheet Wizard’ will ask for the name you
would like to assign to the table to be imported from MS Excel
worksheet. By default it would be having the same name as that of MS
Excel file name containing the worksheet (table) to be imported.
2. Once you click this <Finish> button as shown in Figure 6-14 with
label 2, MS Access will start migrating the data from MS Excel file to
its environment.
If at this point, you want to save the steps of data import you
performed via the wizard.
Figure 6-15: Option of saving the import steps.
________________________________________
At this point you have been given the option to save the steps of import
process. To do this mark the checkbox and click the <Close> button.
The saved import steps can be accessed by first clicking the “External
Data” command and then clicking “Saved Imports” as shown in Figure 6-16.
Select the “stored import steps” and click the “Run” command as shown in
Figure 6-16
Once the import process completes, you will see a message window
updating you regarding the successful completion of the process.
Figure 6-16: Saved Import steps
________________________________________
Figure 6-17: Zoomed version of Figure 6-16
________________________________________
Chapter 6: MS Access Data Import/Export Feature
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Share with others: