Microsoft Office Tutorials and References
In Depth Information
Using XML
Belmont Landscapes has contacts in the building trade industry and gets customer leads
from builders when they sell new homes. One of the builders has several prospective
customers available to Sarah in an XML document, which she wants to add to the Pan-
orama database. XML ( Extensible Markup Language ) is a programming language that is
similar in format to HTML, but is more customizable and suited to the exchange of data
between different programs. Unlike HTML, which uses a fixed set of tags to describe the
appearance of a Web page, developers can customize XML to describe the data it con-
tains and how that data should be structured.
Importing an XML File as an Access Table
Access can import data from an XML file directly into a database table. Sarah’s XML file
is named tblProspect, and you’ll import it as a table with the same name into the Pan-
orama database.
Reference Window |
Importing an XML File as an Access Table
• Click the External Data tab on the Ribbon.
• In the Import group on the External Data tab, click the XML File button to open the Get
External Data - XML File dialog box.
• Click the Browse button, navigate to the location for the XML file, click the XML filename,
and then click the Open button.
• Click the OK button in the Get External Data - XML File dialog box, click the table name
in the Import XML dialog box, click the appropriate option button in the Import Options
section, and then click the OK button.
• Click the Close button.
or
• If you need to save the import steps, click the Save import steps check box, enter a name
for the saved steps in the Save as text box, and then click the Save Import button.
Now you will import the tblProspect.xml document as an Access database table.
To import the XML document as an Access table:
1. Click the External Data tab on the Ribbon (if necessary), and then in the Import
group on the External Data tab, click the XML File button (with the ScreenTip
“Import XML file”). The Get External Data - XML File dialog box opens.
2. Click the Browse button, navigate to and open the Level.02\Tutorial folder, click
tblProspect , and then click the Open button. The selected path and filename now
appear in the File name text box.
3. Click the OK button. The Import XML dialog box opens. See Figure 8-8.
 
Search JabSto ::




Custom Search