Results 1 to 5 of 5
  1. #1
    nello87to is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    14

    Import XML file

    Hello,


    i have a problem with the import of an XML files.
    this is the structure of my file:

    <cube xmlns="http://www.xxx.it" id="AAA_558000" lastObsId="0"> <obs id="0">
    <dim name="VOX" value="0446000" />
    <dim name="CEN" value="0000003765555" />
    <dim name="CRED" value="551000" />
    <dim name="DATA1" value="20140231" />
    <dim name="DATA2" value="20150531" />
    <dim name="PRO" value="467" />
    <dim name="FAL" value="20150630" />
    </obs> </cube>

    Someone know how can I import this kind of file?
    Thanks,
    Nello

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Perhaps I've never come across one like this but the xml's I get look something like this

    Code:
    <?xml version="1.0" encoding="utf-8"?>
    <Orders>
      <Order>
        <OrderID>1514</OrderID>
        <OrderDate>09/11/2015 09:12:25</OrderDate>
    you might find this link helpful

    https://www.lifewire.com/what-is-an-xml-file-2622560

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I agree with Ajax, doesn't look like standard xml I have seen.
    Have you considered reading it as text and parsing?

    Looks like Name and Value pairs.

  4. #4
    nello87to is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    14
    I have some problem modifying this XML because it has more than 1 millions rows. I read something about using XSL file to define the style of the XML file, but I don't know if it works on access 😕

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    suggest go back to the source and see if it can generate a different file

    otherwise try one of the other formats access can import (tho' I don't hold out much hope) or do as Orange suggests.

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

Similar Threads

  1. Import CSV file
    By gg80 in forum Programming
    Replies: 8
    Last Post: 04-08-2014, 09:35 AM
  2. Import of a .WRI-file
    By rndmxy2k13 in forum Access
    Replies: 1
    Last Post: 09-23-2013, 11:42 AM
  3. Import Excel file based on a date and time in file name
    By nhylan in forum Import/Export Data
    Replies: 4
    Last Post: 04-16-2013, 03:26 PM
  4. Import Row 1 Only on a .txt File
    By newbie in forum Import/Export Data
    Replies: 2
    Last Post: 02-08-2011, 08:23 AM
  5. Import XML file
    By randolphoralph in forum Programming
    Replies: 1
    Last Post: 01-22-2010, 09:12 PM

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