Using ImportXML to import xml data into Access tables. I typically,
delete all records in the target table (e.g. the table with the same
name as the xml structure) for the import and then importxml with the
"append data" option. The optional field(s) I am interested in are
included in the definition of the target table.

Having problem with optional fields. Some records have these optional
fields but most don't. My problem is that Importxml does not EVER
import the optional fields.

Suggestions?

Bob

On 7/7/2011 9:37 AM, BobAlston wrote:
I ended up working around this by writing some vba code to traverse the
XML document and finding occurrences of the optional fields. For them I
used DAO logic to update the table previously created by ImportXML.

surely there must be an easier way.

Bob