Import XML file that both appends and updates data?

[Jennifer Robertson]

My goal is to produce an adobe form that produces one xml file, but with
data to be updated in some tables and to be appended in other tables.

I would like to stay away from xml transformations.

Is there a way to iterate though the xml file and pluck out the updates,
then re-iterate though the file and pluck out the appends?

 

[Douglas J. Steele]

Append the XML into a temporary table, then run a query that does the
updates and appends. A single query will do: see my November, 2003 "Access
Answers" column in Pinnacle Publication's "Smart Access". You can download
the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html

 

[Jennifer Robertson]

Thanks I will check it out.

Jen

Append the XML into a temporary table, then run a query that does the
updates and appends. A single query will do: see my November, 2003 "Access
Answers" column in Pinnacle Publication's "Smart Access". You can download
the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html