Microsoft Office Tutorials and References
In Depth Information
You can now export the tblInvoice table as an XML file.
To export the tblInvoice table as an XML file:
1. Open the Navigation Pane, right-click tblInvoice in the Navigation Pane, point to
Export on the shortcut menu, and then click XML File . The Export - XML File dia-
log box opens.
2. Click the Browse button, navigate to and open the Level.02\Tutorial folder, and
then click the Save button. The selected path and filename now appears in the File
name text box in the Export - XML File dialog box.
3. Click the OK button. The Export XML dialog box opens.
Clicking the More Options button in the Export XML dialog box expands the dialog
box and lets you view and change detailed options for exporting a database object
to an XML file.
4. Click the More Options button to reveal detailed export options in the Export XML
dialog box. See Figure 8-12.
Data tab in the Export XML dialog box
click to display
lookup tables for
the tblInvoice table
choices for whi ch
records to export
click to display a list
of files containing
location in which to
export the table (your
path might be different)
The Export Data check box, the Export Location text box, and the Records To
Export option group display the selections you made in the previous step. You’re
exporting all records from the tblInvoice table, including the data in the records
and the structure of the table, to the tblInvoice.xml file in the Level.02\Tutorial
folder. The encoding option determines how characters will be represented in the
exported XML file. The encoding choices are UTF-8, which uses 8 bits to represent
each character, and UTF-16, which uses 16 bits to represent each character. You
can also click the Transforms button if you have a special file that contains instruc-
tions for changing the exported data.
The accounting package doesn’t have a transform file and requires the default
encoding, but Sarah wants to review the tables that contain lookup data.
5. Click the plus box to the left of [Lookup Data]. The tblContract table contains lookup
data because it’s the primary table in the one-to-many relationship with the related
tblInvoice table. The accounting package requirements don’t include any lookup data
from the tblContract table, so make sure the tblContract check box is not checked.
The Data tab settings are correct, so you’ll verify the Schema tab settings.