Share this Page URL

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

Importing and Linking to Data 119 The structure of this table is close to the table as we created it in Chapter 2 and Chapter 3. To work with this table in the ways we defined earlier, you would need to make some refine- ments: · You could rename the ID field ExpenseID. This change isn't required, but the field's name would be more meaningful if you did. · Designate CampaignID rather than Campaign as the foreign key field that's used to create a relationship with the MarketingCampaigns table. · Create an ExpenseType table that lists the categories you track, and convert the Expen- seType field to a lookup field based on values in the ExpenseType table. · Change the ApprovalRequired field to the Yes/No data type. Another change you'll need to make from time to time after importing data into a new table is changing a Number field to a Text field. For example, numerals in a col umn storing postal codes or telephone numbers will be imported as a Number field, but this data is better cate- gorized as a Text field in Access because you won't use the numbers in calculations. Making changes such as these requires some work, but with this import operation you've populated the table with the data you need and have the outline of the table structure as well. Close this version of the HelloWorld database before moving to the next section. 11. Just the Steps Import data from Excel 1. 2. On the File menu, click Get External Data, Import. In the Import dialog box, select Microsoft Excel from the Files Of Type list, and then select the Excel workbook that contains the data you want to import.