Results 1 to 4 of 4
  1. #1
    PeterG is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    5

    Importing DateTimes from XML


    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?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    that is the correct date/time format. It imports just fine from xl files. (but i havnt tried xml)

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    See in the Similar Threads below - Importing XML. Often easier to work with text and parse the text for the data you're interested in.
    It is always helpful if you post samples from your real data and any code you are using/developing.

  4. #4
    PeterG is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    5
    Seems only the ISO standard YYYY-MM-DD works from XML - no idea why that should be : as I said I could copy and paste just about any sensible format just fine. I'm OK now I know though.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Rounding datetimes
    By SeaPorpoise in forum Queries
    Replies: 7
    Last Post: 10-13-2016, 10:08 AM
  2. Importing XML
    By ampd85 in forum Access
    Replies: 4
    Last Post: 04-22-2014, 08:17 AM
  3. Importing a PDF
    By JHighley in forum Access
    Replies: 6
    Last Post: 07-24-2012, 08:39 AM
  4. Need help importing to SQL
    By winterh in forum SQL Server
    Replies: 14
    Last Post: 03-28-2012, 12:36 PM
  5. Help with Importing
    By Souperbc in forum Programming
    Replies: 2
    Last Post: 04-13-2011, 12:45 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums