Problem with Application.ExportXML in Access XP

[Karibusz]

Hi everybody!

I am using the Application.ExportXML method in an Access Data Project (.adp)
to export some SQL Server 2000 data in an XML file. In the resulting XML file
I need decimal numbers of the SQL Server 2000 data to be represented using
the standard "." as the decimal symbol, REGARDLESS of the settings in the
Regional and Language Options, but I observed that the ExportXML method uses
these settings when executed. My operation system is Windows XP Professional
SP2.

Can you give me some suggestions on how to accomplish my goal? Can I set
somehow programatically the settings in the Regional and Language Options to
English before executing the ExportXML method, and then programatically set
them back as they were before?

Any help will be greatly appreciated.

 

[Stefan Hoffmann]

hi,

Can you give me some suggestions on how to accomplish my goal? Can I set
somehow programatically the settings in the Regional and Language Options to
English before executing the ExportXML method, and then programatically set
them back as they were before?

Use XSLT with the TransformXML method.

mfG
--> stefan <--

 

[Karibusz]

Thanks for your answer! Unfortunatelly the TransformXML method was only
introduced in Access 2003, but I'm working in Access XP. There are some other
solutions?

 

[Stefan Hoffmann]

hi,

Thanks for your answer! Unfortunatelly the TransformXML method was only
introduced in Access 2003, but I'm working in Access XP. There are some other
solutions?

Use the Microsoft XML 6.0 Library.

http://www.oreillynet.com/xml/blog/2005/04/transforming_xml_in_microsoft.html


mfG
--> stefan <--