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 4: If Necessary, Specify Each Field Attributes
Figure 6-12: Change field attributes if necessary.
________________________________________
1. Most of the times when you are on this window (Figure 6-12) you have
to just click the <Next> button. For the sake of this example click the
<Next> button too as depicted with label 4.
This step or you can say this window is dedicated for data
transformation purpose. You can assign each field of the data to be
migrated a data type as shown with label 2 but before doing so, you have
to click that particular field as shown in Figure 6-12 with label 1.
Even if you don’t perform this operation, MS Access is intelligent
enough to take care of this part of data import process.
Step 5: Primary Key Field Decision
Figure 6-13: Primary key development option on the fly during the data
import process.
________________________________________
1. Select the option of ‘No Primary Key’ for the sake of this example
and as shown in Figure 6-13 with label 1. If you would like to choose
any column/field for primary key select it from the drop down menu or
otherwise let MS Access to add the primary key field by itself by
selecting the first option i.e. ‘Let Access add primary key’
2. Finally click the <Next> button.
Make sure the column/field you select for primary key, it should not be
having any duplicate values in it.
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: