Results 1 to 9 of 9

Thread: XML Woes (2003)

  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    XML Woes (2003)

    I received 11 XML files I need to import to Access. In the past, I would open them in Excel, convert them then import them to Access. The XML files are now too large for XL (too many records) so I need to import them to Access.

    I have a sample file, Otter.xml I opened in Excel and it opens fine. I import the Otter.xml file to Access and it results in blank tables. I want to have one table that looks like the layout in the Excel table. I trust (hope) there's a simple setting in Access or in the XML files I can modify to accomplish this. All 3 files (XML, XLS, MDB) are included in the zip file for anyone who wants to take a look.

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: XML Woes (2003)

    I have Office XP (2002) at home, which has more limited XML capabilities than Office 2003. Excel 2002 can open the XML file, but although some data are recognizable, many columns are blank. Are you sure the XML is well-formed?
    I won't be able to look at the files in Office 2003 before Monday.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: XML Woes (2003)

    I opened the xml in visual studio.net and looked at it, but It is very odd, so I'm not surprised Access had a problem with it. It appears to contain multiple tables. Was that your intent?
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XML Woes (2003)

    In XL it opens with a single table and is well formatted. If I could get it to come over in 1 table as it appears when opened in XL, I would be fired up. If not, then multiple tables would do.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: XML Woes (2003)

    There's a difference between well formed xml and well-formatted. Access recognizes the tables described in the XML file, but it can't read the fields names, which are captured as attributes rather than as elements, so it can't pull in the data.
    Charlotte

  6. #6
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XML Woes (2003)

    What are my options?

  7. #7
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XML Woes (2003)

    Hans,
    Is there any way to save an XML file via Excel into another format if it exceeds 65,536 rows?
    Thanks!

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: XML Woes (2003)

    I'm sorry, I have very little experience with XML.

  9. #9
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XML Woes (2003)

    Further to what Charlotte mentioned, regarding well formed xml, I ran your xml file through the STG XML Validation Form, with the attached results. Don't know if it will help or not though <img src=/S/question.gif border=0 alt=question width=15 height=15> <img src=/S/question.gif border=0 alt=question width=15 height=15> <img src=/S/question.gif border=0 alt=question width=15 height=15>

    Alan

Posting Permissions

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