.xml file into access 2002

[goslincm]

I'm still trying to resolve this issue. I'm trying to import a simple xml document into access. At the access end, I'm selecting "get external data", highlighting my xml file, and clicking ok. I then indicate to import "structure and data" however I only end up with the structure.

Can anyone help me?

 

[JontyMC]

You cannot import attribute-centric XML in Access

http://support.microsoft.com/kb/q285329/

Jon

"I don't regret this, but I both rue and lament it.

 

[goslincm]

I guess I thought the following was element-centric and it imported with data when I tried with my access program at home but not work. The only difference there was I'm running 2003 at home and 2002 at work.


<?xml version="1.0" encoding="UTF-8" ?>
- <form1>
- <!--
<DropDownList1>County</DropDownList1>
<TextField1>lansing</TextField1>
<DropDownList2>INGHAM</DropDownList2>
<DropDownList4 />
<DateTimeField2>2007-09-13</DateTimeField2>
<DateTimeField1>2007-09-13</DateTimeField1>
<CheckBox1>1</CheckBox1>
<CheckBox2>1</CheckBox2>
<CheckBox3>1</CheckBox3>
<CheckBox4>0</CheckBox4>
<CheckBox5>1</CheckBox5>
<CheckBox6>0</CheckBox6>
<CheckBox7>0</CheckBox7>
<CheckBox8>1</CheckBox8>
<CheckBox9>0</CheckBox9>
<CheckBox10>0</CheckBox10>
<CheckBox11>0</CheckBox11>
<CheckBox12>0</CheckBox12>
<CheckBox13>0</CheckBox13>
<DropDownList3 />
<CheckBox14>0</CheckBox14>
<CheckBox15>0</CheckBox15>
<CheckBox16>0</CheckBox16>
<NumericField4>34343.00000000</NumericField4>
<NumericField5>233.00000000</NumericField5>
<NumericField6>3533.00000000</NumericField6>
<NumericField8>322.00000000</NumericField8>
<NumericField9>2223.00000000</NumericField9>
<Name />
<Address />
<City />
<State />
<ZipCode />
<Country>wd23422</Country>
</form1>