Access.2007.VBA.Bibl..

If you accept the default option of “As an XML table,” you’ll get the message shown in Figure 10.32.

FIGURE 10.32

Creating an XML schema when opening an XML file in Excel.

After accepting this message, the XML file finally opens in Excel, as shown in 10.33, with an extra

column called “generated” indicating the time the file was created.

FIGURE 10.33

An XML file opened in Excel.

If you want to export data from Access to Excel, I recommend using the worksheet or

comma-delimited format instead of XML; they are much easier to work with, and

support older versions of Excel that can’t open XML files.

You can also use the Save method of an ADO recordset with the adPersistXML

named constant as the value of its PersistFormatargument, to produce an XML file,

but a file produced using this method also opens as source code.

NOTENOTE

NOTENOTE

Working with External Data 10