import xml data into Access 2003 - deletes all data in file

[Guest]

All,

I have created an xml file (from a report) that contains 3 types (tables)
of data.

The data structure is similar to:

<root>
<table1>
<row><col1>...</col1>...</row>
<row><col1>...</col1>...</row>
</table1>
<table2>
<row><col1>...</col1>...</row>
<row><col1>...</col1>...</row>
</table2>
<table1>
<row><col1>...</col1>...</row>
<row><col1>...</col1>...</row>
</table1>
<table3>
<row><col1>...</col1>...</row>
<row><col1>...</col1>...</row>
</table3>
.....
</root>

When a do a "get external data" and point to the file that has a
structure similar to above, I receive a display that lists all 3
table structures. I select the first table in the tree list; and
press "OK". I receive a message stating the Import completed
successfully. I check the "TABLE" display and see the 3 tables
defined. All seems ok. (Each table has its own indpendent structure).

When I go to look for the input ".xml" file, it is gone. It's been
deleted.

Is this an error or a new facility that I am not aware of?

Thanks,

Larry

 

[Guest]

Found out by playing around.