MS Access 2003 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

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15

 

Step 7: Write Name for Table & Click Finish

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 the screenshot above, MS Access will start migrating the data from MS Excel file to its environment.

Once the import process completes, you will see a message window updating you regarding the successful completion of the process.

 

Chapter 6: MS Access Data Import/Export Feature

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15

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: