none
Import XML does NOTHING RRS feed

  • Question

  • Thanks for taking the time to read my question.

    I'd like to use MS Access 2010 to import XML files to review the data of all the files together.

    I'm in the "External Data" tab, I click on "XML File", I navigate to my file, Select "Structure and Data" then click OK.

    .... then nothing happens.

    The very first time I tried I received an error: "Error in loading dll". I found this page: https://support.microsoft.com/en-us/kb/2019235 and my registry is now up to date (I navigated to the spot and made sure, and also have made sure both ACEDAO.DLL and dao360.dll exist... they do) I've also restarted and created new accdb databases in different locations, but nothing happens. Any help would be great. Thanks,Brad (Sorry for the poor formatting here... hitting the Enter key is not starting a new line)

    Sorry forgot to include the XML that I'm trying to import as a test:

    <?xml version="1.0" encoding="UTF-8"?>
    <xml850>
    	<Group1>
    		<Field1>Data</Field1>
    	</Group1>
    </xml850>

    • Edited by mbrad Friday, November 6, 2015 7:53 PM added XML
    Friday, November 6, 2015 7:51 PM

Answers

  • Hi,

    When I tried importing your test XML file, it worked for me. Perhaps you could try "repairing" your install of Access or Office. Just a thought...

    • Marked as answer by mbrad Friday, November 6, 2015 10:27 PM
    Friday, November 6, 2015 9:01 PM

All replies

  • Hi,

    When I tried importing your test XML file, it worked for me. Perhaps you could try "repairing" your install of Access or Office. Just a thought...

    • Marked as answer by mbrad Friday, November 6, 2015 10:27 PM
    Friday, November 6, 2015 9:01 PM
  • Repair and reboot is just what the Dr. ordered.

    Thanks for the idea. Import now works.

    Brad

    Friday, November 6, 2015 10:27 PM
  • Hi Brad. Glad to hear you got it sorted out. Good luck with your project.

    Friday, November 6, 2015 10:36 PM