By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,847 Members | 2,261 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,847 IT Pros & Developers. It's quick & easy.

Problem with export data from access 2003 to the xml file, format number are shanged

P: 1
Hallo,
I have next problem: When I'm traying export data from table from one column formated like longint (21,111,111.00 ) form access 2003 to the xml, number looks diferent (<number>21111111</number>, xml format after exporting). Why format number are changed to the integer and not longinteger ?
Thank you so much
Sep 15 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,636
Hallo,
I have next problem: When I'm traying export data from table from one column formated like longint (21,111,111.00 ) form access 2003 to the xml, number looks diferent (<number>21111111</number>, xml format after exporting). Why format number are changed to the integer and not longinteger ?
Thank you so much
It appears as though the Numbers will lose their pre-applied formatting during the XML Export. You can create a Calculated Field in a Query, Format the Numeric Values, convert them to Strings, then Export the Query in order to display properly as in:

Expand|Select|Wrap|Line Numbers
  1. 'Calculated Field in Query
  2. MyNumber: CStr(Format([SomeNumber],"Standard"))
XML OUTPUT:
Expand|Select|Wrap|Line Numbers
  1.  <?xml version="1.0" encoding="UTF-8" ?> 
  2. - <dataroot xmlns:od="urn:schemas-microsoft-com:officedata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="qryXML.xsd" generated="2007-09-16T09:07:38">
  3. - <qryXML>
  4.   <MyNumber>1,234,567.00</MyNumber> 
  5.   </qryXML>
  6. - <qryXML>
  7.   <MyNumber>9,888,866.00</MyNumber> 
  8.   </qryXML>
  9. - <qryXML>
  10.   <MyNumber>32,323,233.00</MyNumber> 
  11.   </qryXML>
  12. - <qryXML>
  13.   <MyNumber>23,232.00</MyNumber> 
  14.   </qryXML>
  15. - <qryXML>
  16.   <MyNumber>232,323,232.00</MyNumber> 
  17.   </qryXML>
  18. - <qryXML>
  19.   <MyNumber>546,565,544.00</MyNumber> 
  20.   </qryXML>
  21.   </dataroot>
Sep 16 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.