Importing XML datetime data

[John Dyer]

I have dates in an XML file that follow the xs:datetime format that I
am trying to import into Access.

A typical date is of the form:
<BirthDate>1989-06-11T00:00:00.0000000-04:00</BirthDate>

When importing the XML file all datetime entries are converted into
text strings. How can I get this data to import as a datetime?

Thanks,
John Dyer

 

[John Nurick]

Hi John,

I'm not too familiar with the XML capabilities of the various versions
of Access but I suspect that the simplest way will be to import it as
text and then use an expression (or VBA custom function) in an Update
query to parse the text and put it in a date-time field.