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
Just like we can export data out from MS Access environment, on the same
lines we can import data into MS Access environment from various
different sources or in other words many different data formats are
accepted by MS Access database for data import.
In this section of the chapter we will be learning in detail how to
implement the Import functionality in MS Access.
Step 1: Start the data Import process
Figure 6-7: Accessing Data Import.
________________________________________
Let’s suppose you want to import the data residing in the MS Excel file
located on your desktop or anywhere in your computer.
1. Click the “External Data” on the menu bar as shown in Figure 6-7 with
label 1.
2. On the ribbon you can see the Import block as shown with label 2.
3. Click the “Excel” command on the ribbon as depicted with label 3.
Step 2: Select Location & File Name
Figure 6-8: Import from MS Excel format.
________________________________________
After the completion of step 1, the ‘Import’ window will popup asking
you to locate the file to be imported, in our case its MS Excel file.
1. Click on the <Browse> button as shown in Figure 6-8 with label 1 to
locate the MS Excel file.
2. As depicted in Figure 6-8 with label 2, we have selected the option
to import data into a new table.
3. Finally click the <OK> button. This will initiate the ‘Import
Spreadsheet Wizard’ window as shown in Figure 6-10.
Figure 6-9: Zoomed version of Figure 6-8.
________________________________________
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: