J
Jeremy Holt
(This may be a double post - apologies)
I've just downloaded Excel 2003 and was messing around with the XML import
function. When importing an ado.net dataset (created with
ds.WriteXML(filename.xml,XmlWriteMode.WriteSchema), Excel does not natively
format dates in the format 2003-08-24T00:00:00.0000000-03:00.
While I could write a parser, I would rather not have to create a new column
to do something which Excel should be able to recognize as a date.
Any thoughts on this?
Thanks
Jeremy
I've just downloaded Excel 2003 and was messing around with the XML import
function. When importing an ado.net dataset (created with
ds.WriteXML(filename.xml,XmlWriteMode.WriteSchema), Excel does not natively
format dates in the format 2003-08-24T00:00:00.0000000-03:00.
While I could write a parser, I would rather not have to create a new column
to do something which Excel should be able to recognize as a date.
Any thoughts on this?
Thanks
Jeremy