I'm trying to import data from .XML with an element that looks like : <dateSeen>02/11/1997 15:57:27</dateSeen> into a corresponding Access table field (appending to existing table) but I just get 00:00:00 in my table. Access table field is formatted General Date. If I open the .XML in notepad and copy and paste the datetime that's fine. Is there any date format I can use that works?