Your XML data may appear to incorrectly import when you try to import that data to Microsoft Office Access 2003 or Microsoft Office Access 2007

Your XML data may appear to incorrectly import when you try to import that data to Microsoft Office Access 2003 or Microsoft Office Access 2007.

This behavior may occur when your XML data contains carriage return line feeds (CRLF) as part of the data. However, the data does successfully import.

To see that your XML data successfully imports, you have to increase the cell height of the table cells so that you can see the data. CRLF causes a blank line above the data. To see the data, follow these steps:

1. In your table, click one of the cells.
2. Click and hold the line under the arrow on the left of the table. Then, drag down to increase the row height.
   
   Note All data in the table appears.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

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.

Access 2003

1. Start Access 2003.
2. On the File menu, click New. In the Task pane, click Blank database, and then click Create.
3. Click File, point to Get External Data, and then click Import.
4. In the Import dialog box, click the folder in the Look in box in which you saved the file in step 3. In the File name box, type States1.xml, and then click Import.
5. In the Import XML dialog box, click OK.
6. In the Microsoft Office Access box, click OK.
7. 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.
8. Click File, point to Get External Data, and then click Import.
9. In the Import dialog box, click the folder in the Look in box in which you saved the file in step 7. In the File name box, type States2.xml, and then click Import.
10. In the Import XML dialog box, click OK.
11. In the Microsoft Office Access box, click OK.
12. 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 Windows Internet Explorer, the data correctly appears.

Access 2007

1. Start Access 2007.
2. Click the Microsoft Office Button, click New, and then click Create to create a new blank database.
3. Click the External Data tab, and then click XML File in the Import group.
4. Click Browse, locate States1.xml, click Open, and then click OK.
5. Click OK in the Import XML dialog box, and then click Close.
6. Repeat steps 3-5 to import States2.xml.
7. Double-click the States1 table in the left pane.
   
   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 Internet Explorer, the data correctly appears.