Export MS access data to XML

[Armele look]

Hello everyone,

I am currently working on a microsoft access project, I need to export the
data to an XML file, I already have a schema that I need to use. Can you
please tell me how to use the existing XSD and XLST files.


Thank You

 

[SteveM]

The method has an attribute for specifying the XSL file to apply.

Isn't the XSD file a definition of a .NET DataSet?

Steve

 

[Armele look]

If you have the code i'll be glad to take it. right now the way i have it is
the following:


Application.ExportXML _
ObjectType:=acExportQuery, _


DataSource:="dischargeREPORT", _
DataTarget:="C:\Documents and Settings\eugenea\My Documents\COREMEASURES
BY FACILITY\test\qipcase" & todayTime & ".xml", _
SchemaTarget:="C:\Documents and Settings\eugenea\My
Documents\COREMEASURES BY FACILITY\test\DISCHARGEREPORT_s" & todayTime &
".xml", _
presentationtarget:="C:\Documents and Settings\eugenea\My
Documents\COREMEASURES BY FACILITY\test\DISCHARGEREPORT_p" & todayTime &
".xsl"