Results 1 to 13 of 13
  1. #1
    Join Date
    Sep 2008
    Posts
    4

    Question Unanswered: Importing XML file into Access

    I've tried importing an XML file into an access database. I check the box that says "structure and data". However, when I import the file, I get the structure and a bunch of records in the tables, but the records contain no data.

    I double checked the XML file and the data is indeed there. Is there some setting I'm missing? Am I not holding my tongue right?

    Thanks!

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Are you using the xml file type for importing? (I believe this is available in Access XP and greater. - if not, try updating the MDAC.)

    Using xml as the import type, I "think" you should then see 2 tables it imports to. One is the structure and the other is the data.

    Try exporting a table from Access as an xml and then importing that xml again. I tried (and only got 1 table), but the data was in it. You might just need to update the MDAC or the file isn't quite in the xml format Access likes.
    Last edited by pkstormy; 09-19-08 at 20:27.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Sep 2008
    Posts
    4
    Well, I tried exporting and importing a table and it worked just fine, so it must be something wrong with my XML. Drat! That's gonna be hard to track down.

    Thanks for the advice, though.

    EDIT: What is the most current version of the MDAC?

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Me, I think it's the way you're holding your tongue ^.^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Quote Originally Posted by dolot
    EDIT: What is the most current version of the MDAC?

    Can't tell you off-hand. Check on microsoft's website though and they should be able to give it to you (along with the MDAC file) - it's a rather long digital number version.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  6. #6
    Join Date
    Apr 2008
    Posts
    189
    Hello,

    Re opening this thread...
    I want to import this XML:

    http://www.google.com/reader/shared/...20601056460271

    How!? How?! I'm getting crazy trying to understand how to make the XSL or XSLT

    Any ideas? Help!?

  7. #7
    Join Date
    Apr 2008
    Posts
    189
    To be more acurate in my needs: I want to import a RSS feed into an Access table.

  8. #8
    Join Date
    Apr 2008
    Posts
    189
    Any ideas how to import an RSS into an Access Table?

    Something like: http://www.google.com/reader/shared/...20601056460271

    The thing is if I import without the XSL or XSLT: I get a mess.

    Any ideas how to import RSSs?

    Thanks!

  9. #9
    Join Date
    Apr 2008
    Posts
    189
    OK, the solution was goes by this way:

    Is needed to convert the Atom from Google Reader into an old RSS.
    I'd used this XSL: http://atom.geekhood.net/
    Used: atom2rss.xsl

    But still don't get it how to "code" in XSL!?

  10. #10
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    But still don't get it how to "code" in XSL!?
    Me either. I am still trying my best to dodge the whole XML thing.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  11. #11
    Join Date
    Apr 2008
    Posts
    189
    yeah... is a very complicated languaje.
    Well, everything is complicated if you don't spend same time on it.

    But, for now: I have my problem -kind of- solve.

  12. #12
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I'm writing some VoiceXML and CallXML and it is not fun. Regarding your issue, other than the coding syntax differences between an XSL and XML file, you should be able to rename the XSL file to an XML extension (and make sure it changes the file type to recognize an XML file.) And then try import into MSAccess using the XML import type.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  13. #13
    Join Date
    Apr 2008
    Posts
    189
    Quote Originally Posted by pkstormy
    I'm writing some VoiceXML and CallXML and it is not fun. Regarding your issue, other than the coding syntax differences between an XSL and XML file, you should be able to rename the XSL file to an XML extension (and make sure it changes the file type to recognize an XML file.) And then try import into MSAccess using the XML import type.
    Sorry, but the XSL is the transformation file that I'm using to import the XML from Google Reader.

Posting Permissions

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