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 6: Primary Key Field Decision

1. Select the option of ‘No Primary Key’ for the sake of this example. 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

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: