many similar XML into tables - can do but need better way

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • johnb180@gmail.com

    many similar XML into tables - can do but need better way

    I need to put xml into tables most often in MS Access using VBA. They
    will each follow the same schema but I will not have the schema and I
    don't need to verify that each follows the same schema other than that
    they have the same name fields.

    This is the limit of my knowledge about xml. Where would you suggest I
    start ?


    How I do it now IF you want to know:
    I have a method of doing so by calling Excel in Access, however it is
    unreliable probably because of the processes communicating through
    files and a lack of a syncronization mechanism.

    John
Working...