Hi, we have a customer recall program which generates a lot of data in XML format. What we would like to do is to bring the XML data into MS Access and analyse it.
The recall program generates two XML files, a reminder file and a suppression file. I would like to import each (one at a time) into a single table for each XML dataset, i.e. tblSuppression and tblReminders.
The problem I am having is that a simple import splits the data into several tables. I understand that I may be able to use an XSLT file to map to the XML but I have no idea where to begin with that.
Searching EE I have found a number of good leads but being a complete novice with XML I've found myself getting a little lost.
I have attached two example files (the data has been altered to protect customer identity). Any help you can offer would be great!
Thanks entity---suppression1648.xml sms-reminders1648.xml