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 3: First Row Contains Heading Check Box
1. Make sure you have selected a correct worksheet as shown in Figure
6-10 with label 1, in case you have multiple worksheets in your MS Excel
workbook file.
2. Click the <Next> button once you have performed step 1 as shown in
Figure 6-10 with label 2.
3. If the first row of your MS Excel worksheet contains fields/columns
headings then make sure this box is checked as shown in Figure 6-11 with
label 1.
4. As soon as you check the box, first row of the data to be imported
gets converted into table headings. This has been shown with the label 2
of Figure 6-11.
5. Finally click the <Next> button.
Figure 6-10: Import Spreadsheet Wizard.
________________________________________
Figure 6-11: Check the box, if first row of the data contains the
columns heading.
________________________________________
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 1 in the Figure 6-11 is unchecked.
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: