Importing an xml file

[goslincm]

I have a file being received from a user that is in .xml and when I go to import the document into Access, it only imports the structure, no data. I am selecting the option to import both data and structure but I'm not getting any data. Any ideas what could be wrong?


<?xml version="1.0" encoding="UTF-8" ?>
- <form1>

<DropDownList1>County</DropDownList1>
<TextField1 />
<DropDownList2>ALLEGAN</DropDownList2>
<DropDownList4>FEBRUARY</DropDownList4>
<DateTimeField2>2007-09-13</DateTimeField2>
<DateTimeField1 />
<CheckBox1>1</CheckBox1>
<CheckBox2>1</CheckBox2>
<CheckBox3>1</CheckBox3>
<CheckBox4>1</CheckBox4>
<CheckBox5>1</CheckBox5>
<CheckBox6>1</CheckBox6>
<CheckBox7>1</CheckBox7>
<CheckBox8>1</CheckBox8>
<CheckBox9>1</CheckBox9>
<CheckBox10>1</CheckBox10>
<CheckBox11>1</CheckBox11>
<CheckBox12>1</CheckBox12>
<CheckBox13>0</CheckBox13>
<DropDownList3 />
<CheckBox14>0</CheckBox14>
<CheckBox15>0</CheckBox15>
<CheckBox16>0</CheckBox16>
<NumericField4>223.00000000</NumericField4>
<NumericField5>222.00000000</NumericField5>
<NumericField6>222.00000000</NumericField6>
<NumericField8>222.00000000</NumericField8>
<TextField9>222</TextField9>
<Name />
<Address />
<City />
<State />
<ZipCode />
<Country />
</form1>

 

[JoeAtWork]

I just tried it in Access2003 and it imported with the data.

 

[goslincm]

I'm working with Access XP, does anyone know if that would be causing me any issues?

 

[JoeAtWork]

Access2003 is AccessXP. Do you have another computer you can test this on?

 

[PHV]

Access2003 is AccessXP
Incorrect as AccessXP is Access2002

 

[goslincm]

Alright, at work I have OS of XP, Access 2002.

I tried running this import at home, where I have OS of XP, Access 2003 and it worked there. Unfortunately however that doesn't help me at this end for work getting the structure and data to import.