Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XML Attributes Access 2003

Status
Not open for further replies.

jlg5454

Technical User
Jan 6, 2005
98
US
I am trying to export a query to XML in Access 2003. The DTD requires attributes. Can this be done without using VBA?




<!ATTLIST day date CDATA #REQUIRED>
<!ATTLIST punch type CDATA #REQUIRED>
 
Yes it can.

You will need to use XSLT to transform the data, which would normally export the data as text nodes within the elements, to attribute values. XSLT's job is to transform an XML document into another XML document, or a text file, or HTML.

In the Access 2003 Export XML dialog box, select Presentation of your data (XSL). The Data check box must be selected for the Presentation of your data (XSL) drop-down box to be available.

You can learn to code a simple XSLT document at
Tom Morrison
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top