P
Pat Hartman
I have a complex XML file from an outside vendor which I need to import into
an Access application. I tried the ImportXML method and that imported the
data into a multitude of tables. The problem is that none of them contain
foreign key data so there is no way to tell which addresses go with which
individuals and which licenses go with which providers. This is the
vendor's standard export schema so he is not willing to change it for us.
Am I reduced to VBA to import this data or is there something I am missing?
an Access application. I tried the ImportXML method and that imported the
data into a multitude of tables. The problem is that none of them contain
foreign key data so there is no way to tell which addresses go with which
individuals and which licenses go with which providers. This is the
vendor's standard export schema so he is not willing to change it for us.
Am I reduced to VBA to import this data or is there something I am missing?