Microsoft Office Tutorials and References
In Depth Information
Access 2003 XML Features
The XML changes in Access include fewer end-user features than Excel and
Word but expand the flexibility and functionality of Access. Now you can
import an XML file (and information from SharePoint Team Services, which also
comes in as XML) directly into your Access data tables. Additionally, you can
export Access data as straight XML, giving you the means to produce data from
a variety of formats in XML output.
From the Experts
Frank Rice, from the MSDN Office Developer Center
(msdn.microsoft.com/office ), thinks the biggest benefit in the XML support
in Access 2003 is that it “allows you to transform an XML form coming in
and an XML form going out. If you’ve got an Adobe file and you’re
translating with an XSL that Access can recognize, when you save it out, you
can use a transformer to transform it back. No data maps are needed.
Access will take a straight XML file and produce a raw XML file as output.
This means you can take a file in another application (such as Lotus
Notes), and a good developer can come up with a transform file for it. So
instead of the two formats being totally incompatible, we can take this file,
run the XSL file to transform the data, and then read it into Access. You
can do the same thing going out.”
Importing XML Data
There are a number of import options when you bring XML data into Access.
A new Import XML dialog box includes an Options button you can click to
display the various types of imports available. (See Figure 5-9.) These choices
enable you to import only the structure of the XML file, import both structure
and data, or append the XML data to an existing Access table.