Microsoft Access 2010 Bible

Chapter 17: Importing and Exporting Data

627

A further refinement of the XML export process is to specify how the XML data should be pre-

sented in an application using the exported data. (The presentation is specified using HTML con-

ventions.) In most cases, the XML presentation file (.xsl extension) is not needed because the

XML consumer application displays the data as required by its users. Figure 17.20 shows the

Export XML dialog box’s Presentation tab. Notice that none of the options on this tab is selected by

default.

FIGURE 17.20

XML presentation options

To import that same XML document just created, select the External Data tab, browse to the XML

file in the Import section, and click OK. The process is similar to exporting, except in reverse.

Importing an HTML document

Access enables you to import HTML tables as easily as any other database, Excel spreadsheet, or

text file. You simply select an HTML file to import and use the HTML Import Wizard. The HTML

Import Wizard works exactly like the other import wizards described earlier in this chapter.

And just like demonstrating XML in the previous section, I’ll do an HTML import in reverse as

well. First, you export a table to generate an HTML file, then import the file back into Access to

create a new table:

1. Open the Chapter17_1.accdb database.


2. Under the External Data tab, click the More drop-down button in the Export group and
   select HTML File.


3. Specify an HTML file as the export destination in the Export HTML dialog box (see
   Figure 17.21).