Resolved MS Access 2007 does not import XML in Windows 7

Access 2007


The first step is to prepare the XML file and to open the database into which you want to import the XML file, or create a new database.


Click on the External Data tab in the Access ribbon. The menu options that appear lets you import data from various sources like text files, ODBC database, HTML document, XML files, dBASE files, Lotus 1-2-3 file etc. Click on the XML file menu item.


The 'Get External Data - XML File' dialog appears.
Locate the XML file by clicking on Browse and navigating to the file. Once the file is selected, click OK. The Import XML dialog appears, which is similar to the one in Access 2003 with additional options of "˜Import Structure Only’, "˜Import Structure and Data’ and "˜Append Data to Existing Table(s).


Select the option you want and click OK. When using Windows 7 nothing else happens.
The process just terminates. Importing the XML file to Excel and then from Excel to Access works but is certainly not very efficient.

The next screen that appears offers an option not available in Access 2003. This screen notifies you that Access has finished importing the data and asks you if you want to save the import steps. This is, in a way, similar to a macro. If you choose to save the import steps, you can run it later anytime you need it. This will create the table by importing the data from the XML file without having to go through the entire process again. This may come in handy in some situations.


If you check the box 'Save import steps,' it will ask you to enter a name for the import steps, enter a description (optional), and click on 'Save Import'. If you don't want to save your import steps, just click on 'Close'.

Procedure excerpted from brighthub.com

Read more: http://www.brighthub.com/computing/windows-platform/articles/29758.aspx#ixzz1Y972lR89

 

Issue not Resolved

The process does not work as advertised!

The issue has not been resolved.

 

Then why mark it as "Resolved" ?

 

I didn't.

 

Issue not resolve but I have moved on

Installed 64 bit MS Office and it solved the XML issue.