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 3: First Row Contains Heading Check Box
1. Make sure you have selected a correct
worksheet, in case you have multiple worksheets in your MS Excel
workbook file. Click the <Next> button once done.
2. If the first row of your MS Excel worksheet contains
fields/columns headings then make sure this box is checked.
3. Finally click the <Next> button.
There are rare cases where you don’t have any fields/columns name as the
first row or in other words your data starts from the very first row of
your MS Excel worksheet. For such cases make sure the Check box
mentioned with label 2 in the slide above is unchecked.
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: