Import XML does NOTHING

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>

Answer 1

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...

Answer 2

Repair and reboot is just what the Dr. ordered.

Thanks for the idea. Import now works.

Brad

Answer 3

Hi Brad. Glad to hear you got it sorted out. Good luck with your project.