Export MS access data to XML

[Guest]

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

 

[Guest]

Take a look at the ExportXML and TransformXML methods.

Steve

 

[Guest]

Thanks Steve.

I tried that but I can't get it to work. Do you have a specific code?

 

[Guest]

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

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

Steve

 

[Guest]

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"