Share this Page URL

Chapter 4. Importing and Linking to Data > Importing Data - Pg. 113

Importing and Linking to Data 113 5. When the data is imported, Access will match the column names with the field names defined in the table. If you haven't confirmed that the worksheet's column headings match the table's field names, now is a good time. If you don't select the option First Row Contains Column Headings, the wizard gives you only the option to import the data into a new table (in its next screen). Click Next. Select In An Existing Table, and then select CampaignExpenses from the list of tables, as shown here. Click Next.