Connecting Tech Pros Worldwide Help | Site Map

Excel 2007 crashes importing simple xml file

  #1  
Old October 4th, 2008, 08:35 AM
James Minns
Guest
 
Posts: n/a
Hi all,
I have a problem with Excel 2007: it crashes when importing certain xml
data, exported from another software
This is the smallest file which reproduces the problem:

<?xml version="1.0" standalone="yes"?>
<ds_S3 xmlns="http://tempuri.org/ds_S3.xsd">
<tblTags>
<StartDateAndTime>2000-01-01T00:00:00+01:00</StartDateAndTime>
</tblTags>
</ds_S3>


The problem is caused by the StartDateAndTime value: importing this file
works:
<?xml version="1.0" standalone="yes"?>
<ds_S3 xmlns="http://tempuri.org/ds_S3.xsd">
<tblTags>
<StartDateAndTime>this works...</StartDateAndTime>
</tblTags>
</ds_S3>


I don't expect Excel to interpret the date - just to show it as a string!
Anyone confirm or deny this? any solutions?

Info:
OS: Vista Business SP1, English
Excel 2007 SP1, English
Regional settings: Italian (tried US but no difference)


Thanks,
James

Closed Thread