Your XML data may appear to incorrectly import when you try to import that data to Microsoft Office Access 2003 (887035)

MORE INFORMATION

Steps to reproduce the behavior

1. Click Start, click Run, type Notepad, and then click OK.
2. Put the following code example in Notepad.

   <?xml version="1.0" encoding="UTF-8"?>
   <dataroot>
   <States>
    <State>NC</State>
   </States>
   <States>
    <State>TX</State>
   </States>
   <States>
    <State>WA</State>
   </States>
   <States>
    <State>NY</State>
   </States>
   <States>
    <State>CA</State>
   </States>
   </dataroot>

3. Click File, and then click Save. In the File name box, type States1.xml, and then click Save.
4. Close Notepad.
5. Click Start, click Run, type Notepad, and then click OK.
6. Put the following code example in Notepad.

   <?xml version="1.0" encoding="UTF-8"?>
   <dataroot>
   <States>
    <State>NC</State>
   </States>
   <States>
    <State>TX
   </State>
   </States>
   <States>
    <State>
   WA
   </State>
   </States>
   <States>
    <State>
   NY</State>
   </States>
   <States>
    <State>CA</State>
   </States>
   </dataroot>

7. Click File, click Save, type States2.xml, and then click Save.
8. Close Notepad.
9. Start Access 2003.
10. Click File, and then click New. In the Task pane, click Blank database, and then click Create.
11. Click File, point to Get External Data, and then click Import.
12. In the Import dialog box, click the folder in the Look in box where you saved the file in step 3. In the File name box, type States1.xml, and then click Import.
13. In the Import XML dialog box, click OK.
14. In the Microsoft Office Access box, click OK.
15. In the Database window, click Tables in the Objects pane, and then double-click the States table.
    
    Note The States table opens and the data correctly appears.
16. Click File, point to Get External Data, and then click Import.
17. In the Import dialog box, click the folder in the Look in box where you saved the file in step 7. In the File name box, type States2.xml, and then click Import.
18. In the Import XML dialog box, click OK.
19. In the Microsoft Office Access box, click OK.
20. In the Database window, click Tables in the Objects pane, and then double-click the States1 table.
    
    Note The States1 table appears to be missing "WA" and "NY." However, "WA" and "NY" are there. To see "WA" and "NY," follow these steps:
    1. In the States1 table, click WA.
    2. Click and hold the line under the arrow on the left of the table. Then, drag down to increase the row height.
       
       Note You can now see all the data in the table. "WA" and "NY" have blank lines above them. Therefore, you cannot see them unless you increase the row height.
    If you open either States1.xml or States2.xml by using Microsoft Internet Explorer, the data correctly appears.