Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2011
    Location
    WA, US
    Posts
    5

    Unanswered: Importing XML into Access

    Good Afternoon All

    I am trying to import a fairly large XML file into Access. Access will import the structure but no data. I know nothing at all about XML so I am looking for a way to get the data into the only db tool I have - Access. The file is about 12 Meg (ftp://ftp****m.nih.gov/nlmdata/sample/hsdb) and I haven't a clue at what I need to do to pull it in.

    Suggestions, clues, alternatives, software (free preferably)???

    I can see all the data in my XMLNotePad but its too much to edit manually.

  2. #2
    Join Date
    Oct 2009
    Posts
    340
    I have no assist......am just wondering as to 'then what' ?.... what is the xml codes purpose?
    www CahabaData com

  3. #3
    Join Date
    Jun 2011
    Location
    WA, US
    Posts
    5
    ftp****m.nih etc.

    The xml file is a really long data file (3 Meg not 12) of chemical information. I would like to extract some chemical physical info into a smaller, compact database. The smaller subset would be used as a look up table for calculations

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    in A2010 you can import XML data natively get external data
    don't know (or should that read forget) about other versions.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jun 2011
    Location
    WA, US
    Posts
    5
    I tried to import the xml data in A2010 and it gave me an error on each line of data. I may have have to get more familiar with XHTML, XSLT, and the whole area I was tryng to avoid -- old dog new tricks.

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I imported several XML files into Access with no problems so I'd guess either there DTD / XLMS is wrong or the actual XML stream is corrupt
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •