xml import

[goslincm]

I guess this will be my last plea for help as to why an xml file will import the data into access 2003 (on my home PC) but not import the data, only the fields, on my work PC.

In both importings I'm indicating to indicate data and structure. Could it be the difference between versions? Perhaps a restriction at the end of my work environment?

Help....

 

[KenHigg]

I would check MS Access->Help->About Microsoft Access on both sets. Then check and see if the references were the same...

Can you post a sample xml file and see if it imports on my machine?

Ken

 

[goslincm]

xml

<?xml version="1.0" encoding="UTF-8" ?>
- <form1>
- <!-- ->
<DropDownList1>City</DropDownList1>
<TextField1>gagetown</TextField1>
<DropDownList2>TUSCOLA</DropDownList2>
<DropDownList4>FEBRUARY</DropDownList4>
<DateTimeField2>2007-09-19</DateTimeField2>
<DateTimeField1>2007-09-19</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>0</CheckBox11>
<CheckBox12>0</CheckBox12>
<CheckBox13>0</CheckBox13>
<DropDownList3>Adverse</DropDownList3>
<CheckBox14>0</CheckBox14>
<CheckBox15>0</CheckBox15>
<CheckBox16>1</CheckBox16>
<CheckBox17>1</CheckBox17>
<TextField2>$232,000,323</TextField2>
<TextField3>$293,098</TextField3>
<TextField4>$232,000</TextField4>
<TextField5>$(323,000)</TextField5>
<TextField6>$323,302</TextField6>
<TextField7 />
<TextField8 />
<TextField9>LONG STREET ADDRESS</TextField9>
<TextField10>BIG CITY</TextField10>
<TextField11>Mi</TextField11>
<TextField13 />
<TextField14>493928</TextField14>
</form1>

 

[KenHigg]

Hum... It gave me an error as well...

 

[goslincm]

What version of access are you working with?

 

[KenHigg]

2003 sp2 ?

 

[goslincm]

xml import troubles

well that suprises me because I'm using 2003 at home where it did work for me.