Database Reference
In-Depth Information
Exporting to .html files
Many organizations that store accounting, manufacturing, marketing, sales, and other in-
formation on their computers have discovered the advantages of sharing this information
within the company or with the rest of the world through a website. With Access, you can
export tables, queries, forms, and reports as web-ready .html files. You can then view the
objects in a web browser, such as Windows Internet Explorer.
When you export a table, query, or form, Access converts it to an HTML table. When you
export a report, Access converts it to a series of linked .html files (one for each page of the
report).
TIP
To display the HTML tags that define the structure of the file, you can either view the
file in a web browser or open it in a text editor.
Exporting to .xml files
You can export tables, queries, forms, and reports from Access in an XML format that can
be used by other applications. To export to an .xml file:
In the
Export
group on the
External Data
tab, click the
XML File
button to start the
Export
wizard, in which you specify the destination location and assign a name.
1
Click
OK
to open the
Export XML
dialog box, in which you can do one of the
following:
▪
Select the
Data (XML)
check box to export the data.
▪
Select the
Schema of the data (XSD)
check box to create a separate .xsd schema
that contains the structure of the XML data.
▪
Select the
Presentation of your data (XSL)
check box to export an .xls stylesheet
that describes how to display the XML data.
2
10
TIP
To export a table as a combined data/schema file, in the Export XML dialog
box, click More Options, click the Schema tab, click Embed Schema In Exported
XML Data Document, and then click OK.
Click
OK
to save the object with your specifications. The
Export
wizard then gives
you the opportunity to save the export steps.
3
You can view the tagged .xml file in Internet Explorer and the .xsd file in any text editor.
