Microsoft Access 2010 Bible

Chapter 17: Importing and Exporting Data 613 FIGURE 17.3 The Saved Import Steps feature lets you save frequently executed import ...

Part III: More-Advanced Access Techniques 614 Tip The Manage Data Tasks dialog box includes the Create Outlook Task button to se ...

Chapter 17: Importing and Exporting Data 615 FIGURE 17.6 Excel worksheet columns should contain consistent data. Data has been c ...

Part III: More-Advanced Access Techniques 616 On the next screen (shown in Figure 17.8), select the First Row Contains Column H ...

Chapter 17: Importing and Exporting Data 617 FIGURE 17.9 You can override any of the default settings Access has chosen. Overrid ...

Part III: More-Advanced Access Techniques 618 Cross-Reference Primary keys are discussed in Chapters 2 and 3. Specify the new t ...

Chapter 17: Importing and Exporting Data 619 4,Peacock,Margaret,5/3/15 0:00:00,4000 5,Buchanan,Steven,10/17/15 0:00:00,5000 6,Su ...

Part III: More-Advanced Access Techniques 620 As you can see in Figure 17.12, this screen enables you to specify the separator u ...

Chapter 17: Importing and Exporting Data 621 Tip To specify a field containing no data in a delimited file, leave no characters ...

Part III: More-Advanced Access Techniques 622 Select Fixed Width and click Next. The next screen of the Import Text Wizard (sh ...

Chapter 17: Importing and Exporting Data 623 Click the Advanced button at the bottom of the wizard. The Import Specification d ...

Part III: More-Advanced Access Techniques 624 One advantage of using the Import Specification dialog box is the capability to sp ...

Chapter 17: Importing and Exporting Data 625 Follow these steps to export data from Access to an XML file: Open the Chapter17_1 ...

Part III: More-Advanced Access Techniques 626 FIGURE 17.18 Advanced XML export options The data contained in an XML file may be ...

Chapter 17: Importing and Exporting Data 627 A further refinement of the XML export process is to specify how the XML data shoul ...

Part III: More-Advanced Access Techniques 628 FIGURE 17.21 The HTML Export dialog Follow the next screens to select your HTML o ...

Chapter 17: Importing and Exporting Data 629 FIGURE 17.22 The same wizard imports objects and links to external Access tables. ...

Part III: More-Advanced Access Techniques 630 When including tables, queries, forms, reports, macros, or modules — all in the sa ...

Chapter 17: Importing and Exporting Data 631 Selecting the import option opens the Import Exchange/Outlook Wizard (shown in Figu ...

Part III: More-Advanced Access Techniques 632 FIGURE 17.26 Browsing to a dBase data file Table 17.1 lists how the dBase data typ ...